topic Re: Not Equal condition in Set analysis in QlikView

Not Equal condition in Set analysis

Anonymous — Sat, 15 Aug 2015 06:29:08 GMT

Dear All,

i need to write not equal condition to filter dimensions in set analysis.

Now am using if condition so it take long time to load chart user get hesitate.

if(BasePrice<>Price,Supervisor)

i need to change this into set analysis

Kindly help to achieve this.

Thanks in advance

Regards

Siraj

MK_QSL — Sat, 15 Aug 2015 07:03:13 GMT

Only({<BasePrice -= {'Price'}>}Supervisor)

Anonymous — Sat, 15 Aug 2015 07:40:14 GMT

It shows the "error in the Calculated dimension " error message.

Kushal_Chawda — Sat, 15 Aug 2015 08:11:24 GMT

Create calculated dimension as

aggr(Only({<Supervisor-={"=BasePrice=Price"}>}Supervisor),Supervisor)

or Expression

Only({<Supervisor-={"=BasePrice=Price"}>}Supervisor)

MK_QSL — Sat, 15 Aug 2015 08:38:56 GMT

Let me know where you want to use it and how?

If you want to count, use formula suggested by

COUNT({<Supervisor = {"=BasePrice = Price"}>}Distinct Supervisor)

If you don't want Distinct, you can ignore it.