Discussion Board for collaboration on QlikView Scripting.
Not sure if this is possible.
I'm having simple script like below:
month(Date) as Month,
year(Date) as Year
I have created below table in front end:
Is there any possibility that I can call count(Month) in a list box to get these numbers as a list????
Go to Solution.
I think I got it. This is working
=Aggr(Count(Month), Firstname, LastName)
May be try like this,
Add expression in the listbox
Exp: = Count(Month)
=Aggr(Count(Month), [First Name])
Sorry Sunny , it's showing me '-'
I have tried something like below:
and this is working , but i believe this is count of Date not Month
Yeah, you can......
Just use aggr() function in listbox expression intead of field....
Something like suggested by Sunny T
I have already tried this , not working.
Actually I'm facing issue below:
Some cases it is working fine like below
in some cases not like below:
Try like this