Condition on a column

[#1]

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

[vishsaggi]

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])

[Digvijay_Singh · Accepted solution]

Check this -

[#4]

That's exactly what i'm looking for.

Thank you