Discussion Board for collaboration related to QlikView App Development.
Consider 3 fields from a table.
from this table, i need to get the Names which are on saturday's (26,19,12).
Like below, can we achieve this using firstsortedvalue function.? or with something else?
What i want is like below, It should pick only saturday on max Date and Previous Date and those corresponding values.
You may use this for calculated Dim and use Name
If(WeekDay(Date) = 'Sat', Date)
Then Expresssion could be Sum(Profit)
This might help you :
Hi ill change my requirement.
Can you please help me.