topic Re: Condition on a column in QlikView

Condition on a column

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Condition on a column

vishsaggi — Thu, 27 Apr 2017 19:42:18 GMT

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

Re: Condition on a column

Digvijay_Singh — Thu, 27 Apr 2017 20:15:35 GMT

Check this -

Re: Condition on a column

Fri, 28 Apr 2017 08:11:10 GMT

That's exactly what i'm looking for.

Thank you