Qlik Sense Tutorial | Qlik Sense Script and Chart Function - First Sorted Value

[@bibinlalb7543]

Hi Abhishek,
If I want load first 10 values..what changes we need to do ???

[@chillasuvarna3319]

Hi Abhishek...well explained...could you please explained about nested if statement in qliksense how does it works actually

[@noronhasanjay]

Thanks for a very useful video Abhiskek. For the FirstSortedValue() you chose a Measure to enter the function details. But this is text and not numeric i.e. Product. So why not use a dimension?

[@Muthukumar-jt8mx]

Well explained..

[@RameshMuthuk1596]

very useful one .. thanks man

[@shreshthasarkar991]

Thank You for the videos

[@Muthukumar-jt8mx]

Hi Abhishek, Can you plase explain How to removed duplicate values

[@AbhishekAgarrwal]

Hi Muthu.. you need to use the DISTINCT keyword prior to field name to remove duplicate values.

[@amitbhandari6797]

i,
I want to have a new column on a table that gives me the first column that has a specific value.
So,
I have this

Header 1 Header 2 Header 3 Header 4 Header 5
Name Month1 Month2 Month3 Month4
A 0 0 3 3
B 0 4 0 1
C 0 3 2 1
D 1 0 0 1
I would like to add a column with the name of the first column that has a value higher than 0.
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6
Name Month1 Month2 Month3 Month4 FirstMonthSales
A 0 0 3 3 Month3
B 0 4 0 1 Month2
C 0 3 2 1 Month2
D 1 0 0 1 Month1
So, the FirstMonthSales column should have the first month that has a value higher than 0.

[@anilkumar-wl9wn]

Hi