topic Re: No display data problem in QlikView

No display data problem

Mon, 04 Nov 2013 06:07:53 GMT

Hi all

i have a problem in expression...i have a table named "A".

in that i have a monthly record.. 3 column one of them is flag and one of them is customer id and month code...

i want to have chart with month dim and in that show count of customer that the flag for them is 0 in current month and 1 in previous month...

i really want the answer ...

please help me in this situation...

Regards.

sahar

Re: No display data problem

tresB — Mon, 04 Nov 2013 06:24:59 GMT

Try expressions like:

=Count( Distinct If( Flag=0, [Customer ID])) // For Current month

=Count( Distinct If( Flag=1, [Customer ID])) // For Previous month

Or, using set, like:

=Count( {<Flag={1}>} distinct [Customer ID])

=Count( {<Flag={0}>} distinct [Customer ID])

In the dimension Month field.

Re: No display data problem

sibin_jacob — Mon, 04 Nov 2013 06:48:08 GMT

HI Sahar,

Please find the attached document.

I used the below expressions to get the count

Count({$<Flag={0}>}CustomerID)

Count({$<Flag={1}>}CustomerID)

I hope this helps! Let me know incase of any concerns/questions.

Thanks,

Sibin Jacob. C

Re: No display data problem

Mon, 11 Nov 2013 06:46:32 GMT

hi all

thanks for your kindly reply... but one think i forgot to say is the dimension of my chart in this case is month ....

and for each month i want to show the count of customer that the previous flag for them is 0 and current flag is 1 ... actually this diagram suppose to show churn ...

Regards..

saha