topic Re: Set Analysis Not Equal To in QlikView

Set Analysis Not Equal To

infock12 — Mon, 23 Nov 2015 11:03:23 GMT

Hi all,

I tried to write the below set analysis expressions:

=Num(count({<GRating={'<=6'}, GRating=-{'Not Applicable'}, GRating=-{'Not applicable'}>} GQuestions)/Count({<GRating=-{'Not Applicable'}, GRating=-{'Not applicable'}>}GQuestions), '0.00%')

=Num(count({<GRating={'<=6'}, GRating={'-=Not Applicable'}, GRating={'-=Not applicable'}>} GQuestions)/Count({<GRating={'-=Not Applicable'}, GRating=-{'-=Not applicable'}>}GQuestions), '0.00%')

The first expression with the '=-' (Not equal to) sign outside the brackets and the second one inside the brackets.

hat I am trying to achieve is:

1. Count all GQuestions that has a GRating of <=6 and Divide it by Total GQuestions.

2. Exclude all GRating that has a value of 'Not Applicable' and 'Not applicable' (the first 'not applicable ' is with a capital A and the second with a small 'a' hence the difference).

The above script gives me all 100%. Please could you let me know what I am doing wrong. I tried the ,<> instead of -= as well but it didn't work either.

Thanks,

Karthik

Re: Set Analysis Not Equal To

MK_QSL — Mon, 23 Nov 2015 11:07:29 GMT

not equal to in set analysis

Re: Set Analysis Not Equal To

rubenmarin — Mon, 23 Nov 2015 11:08:14 GMT

Hi Karthik, can you try this?:

=Num(count({<GRating={'<=6'}>*<GRating=-{'Not Applicable','Not applicable'}>} GQuestions)/Count({<GRating=-{'Not Applicable','Not applicable'}>}GQuestions), '0.00%')

Re: Set Analysis Not Equal To

rubenmarin — Mon, 23 Nov 2015 11:11:06 GMT

Or:

=Num(count({<GRating={'<=6'}-{'Not Applicable','Not applicable'}>} GQuestions)/Count({<GRating=-{'Not Applicable','Not applicable'}>}GQuestions), '0.00%')

Re: Set Analysis Not Equal To

swuehl — Mon, 23 Nov 2015 11:12:43 GMT

Try

=Num(count({<GRating = {"<=6"} >} GQuestions) / Count({<GRating -= {"Not Applicable"}>} GQuestions), '0.00%')

Re: Set Analysis Not Equal To

infock12 — Mon, 23 Nov 2015 11:19:45 GMT

Hi Sweuhl and Ruben,

All of your answers work. Amazing, thank you very much!