Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Condition on a column

Hello QV community,

I'm new to qlikview and am hving this issue :

I have a table with this structure

PageNumber of fansYearMonth
page 11000201701
Page 23400201701
Page 11100201702
Page 11250201703

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

1 Solution

Accepted Solutions
Digvijay_Singh

3 Replies
vishsaggi
Champion III
Champion III

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

Not applicable
Author

That's exactly what i'm looking for.

Thank you