topic Re: Gauge Chart not changing in QlikView

Gauge Chart not changing

infock12 — Thu, 27 Aug 2015 18:33:07 GMT

Hi all,

I am using a simple gauge chart and a simple expression

=Num(count({<GRADE={'SAFE'}, Gscore={'>=7'}>}Questions)/Count({<GRADE={'SAFE'}>}Questions), '#,##0.0%')

What I am saying is to give the percentage of total questions which has a Gscore of more than 7 for GRADE=SAFE. It works fine when I don't apply any filter.

However, I have a list box for Gscore, and when I select any value between 1 to 10, the needle in the gauge chart goes to >100%. When my condition asks to count only scores >=7, and if I select 4, the needle should go to Zero because 4 is not more than or equal to 7. I know I am doing something wrong because I am explicitly counting only >=7 but I can't figure out what.

What I wanted is that if I select any value from the GScore list box, the gauge should give me the right percentage. For example, if I select 3 in the Gscore list box, I should get 0 because it is less than 7. If I select 8, it should count only the 8s and give me the percentage.

Please help. Perhaps, I should remove "Grade='SAFE'" from the expression and use something like GetSelectedCount or something??

I have attached the data and qvw.files.

Thanks,

Karthik

Re: Gauge Chart not changing

swuehl — Thu, 27 Aug 2015 18:37:45 GMT

Try with the intersection operator * :

=Num(count({<GRADE={'SAFE'}, Gscore *= {'>=7'}>}Questions)/Count({<GRADE={'SAFE'}>}Questions), '#,##0.0%')

Re: Gauge Chart not changing

infock12 — Thu, 27 Aug 2015 18:48:14 GMT

Hi Stefan,

Thanks for the quick reply. It works for Scores less than 7, which is great! However, anything from 7 onwards it again goes to more than 100%. Looks like there is something very simple I am missing?

Thanks,

Karthik

Re: Gauge Chart not changing

swuehl — Thu, 27 Aug 2015 20:05:03 GMT

Seem like you want the denominator to be not affect by selections in Gscore.

Try

=Num(count({<GRADE={'SAFE'}, Gscore *= {'>=7'}>}Questions)/Count({1<GRADE={'SAFE'}>}Questions), '#,##0.0%')

if you want to ignore any selections, or

=Num(count({<GRADE={'SAFE'}, Gscore *= {'>=7'}>}Questions)/Count({<GRADE={'SAFE'}, Gscore= >}Questions), '#,##0.0%')

when only selections in Gscore shall be ignored.

Re: Gauge Chart not changing

infock12 — Fri, 28 Aug 2015 11:47:24 GMT

Hi Stefan,

It worked. Thank you very much for your help!

Regards,

Karthik