topic Re: Set analysis and intersect in QlikView

Set analysis and intersect

mustafaelryah — Tue, 01 Sep 2015 08:34:44 GMT

Dear All,

I used set analysis to avoid showing one value , take a look to the below picture :

I don't want (NON-Budgeted ) to appear on this chart, so I used the below Set Analysis:

Sum({$<Account_Budget -= {'NON-Budgeted','-','0'}>} balance)

this hide the value of (NON-Budgeted) but the label is still shown on the chart, what could I do?

Regards

Re: Set analysis and intersect

jonathandienst — Tue, 01 Sep 2015 08:42:47 GMT

That should be:

Sum({$<Account_Budget -= {'NON-Budgeted'}>} balance)

(the other values wont do anything useful)

I suggest that you post your qvw or a representative sample.

Re: Set analysis and intersect

Marcoimp — Tue, 01 Sep 2015 08:44:17 GMT

In your graph I see more then 2 bars for each label.... could you explain better? Maybe the label is referred to some other value...

Re: Set analysis and intersect

mustafaelryah — Tue, 01 Sep 2015 08:46:12 GMT

also I need it without 0 or -

Re: Set analysis and intersect

mustafaelryah — Tue, 01 Sep 2015 08:56:44 GMT

find the application below here

https://www.dropbox.com/s/g9s1n0509ppa3sq/ALrugaib%20BI.qvw?dl=0

Re: Set analysis and intersect

mustafaelryah — Tue, 01 Sep 2015 08:56:55 GMT

find the application below here

https://www.dropbox.com/s/g9s1n0509ppa3sq/ALrugaib%20BI.qvw?dl=0

Re: Set analysis and intersect

sasiparupudi1 — Tue, 01 Sep 2015 09:11:20 GMT

change Account_Budget dimension to a calculated dimension with an if condition like

if(Account_Budget='ON-Budgeted','',Account_Budget)

hth

Sasi

Re: Set analysis and intersect

Marcoimp — Tue, 01 Sep 2015 09:36:15 GMT

If you delete the set analysis, you can see the null dimension anyway...!!

The problem seems to be the dimension and not the expression... could be?

Re: Set analysis and intersect

jagan — Tue, 01 Sep 2015 09:42:48 GMT

Hi,

I think you need to select Supress Null value in Dimension as well as Presentation tab.

Hope this helps you.

Regards,

Jagan.

Re: Set analysis and intersect

mustafaelryah — Thu, 03 Sep 2015 06:22:17 GMT

I didn't got you friend , sorry

Re: Set analysis and intersect

mustafaelryah — Thu, 03 Sep 2015 06:29:26 GMT

Thanks a lot Sasidhar Parupudi

Re: Set analysis and intersect

jagan — Thu, 03 Sep 2015 07:49:09 GMT

Hi Mustafa,

Calculated Dimension have performance issues, so it is suggested to use set analysis like below

Sum({<Account_Budget={'ON-Budgeted'}>} Account_Budget)

Hope this helps you.

Regards,

Jagan.