Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QV community,
I'm new to qlikview and am hving this issue :
I have a table with this structure
Page | Number of fans | Year | Month |
---|---|---|---|
page 1 | 1000 | 2017 | 01 |
Page 2 | 3400 | 2017 | 01 |
Page 1 | 1100 | 2017 | 02 |
Page 1 | 1250 | 2017 | 03 |
I want to display in a text object the number of fans when i select the page name, the year and the month. Also i want to display the number of fans of the previous month. I'm having some issues writing the expression.
For exemple if i select page 1, 2017, 03 i need a result like this :
Number of current fans : 1250
Number of fans in the previous month : 1100
I hope u can help
Check this -
Try this may be:
Num of Current Fans: = Sum({$} [Number of fans])
Num of Fans in Previous Month: = Sum({< Month = {"$(= Num(Month-1, 0&'0'))"} >} [Number of fans])
Check this -
That's exactly what i'm looking for.
Thank you