topic Re: Gauge chart not displaying count with conditional expression in QlikView

Gauge chart not displaying count with conditional expression

Wed, 01 Aug 2012 09:26:03 GMT

I am new to QlikView and I am trying to display some gauge charts which display different aspects of a campaign.

Gauge chart 1 - Displays number of payees

Expression: =if([Campaign Type]='Paid', Count (DISTINCT [Member ID]), 0)

This is displaying the correct numbers for campaigns.

Gauge chart 1 - Displays number of complimentary places

Expression: =if([Campaign Type]='Complimentary', Count (DISTINCT [Member ID]), 0)

This continues to display 0 despite there being records with 'Complimentary' as a value. Any ideas as to what I'm doing wrong?

Thanks in advance for any help...

Re: Gauge chart not displaying count with conditional expression

Anonymous — Wed, 01 Aug 2012 09:32:32 GMT

Can you please provide some sample data..

Re: Gauge chart not displaying count with conditional expression

Wed, 01 Aug 2012 10:42:26 GMT

You ask QlikView "if the dimension [Campaign Type] equals 'Paid' (aka the selection I've made on the [Campaign Type] field), then do me the count for all possible values".

I think you want to ask "do me the count for items where [Campaign Type] equals 'Paid'".

Try

=Count (DISTINCT if([Campaign Type]='Paid', [Member ID]))

and

=Count (DISTINCT if([Campaign Type]='Complimentary', [Member ID]))

and don't do any selection.

Re: Gauge chart not displaying count with conditional expression

Wed, 01 Aug 2012 11:17:08 GMT

Legend! Thanks, Nicolas.