topic Re: Ignore certain selections in SET Analysis in QlikView

Ignore certain selections in SET Analysis

psk180590 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a bar chart with the following expression

Sum({<Markt={'N07C'},Region=, Area=, FBNum=, Product = {'VERT'},Year={'2018'}>}Sales)

Sum({<Markt={'N07C'},Region=, Area=, FBNum=,Product = {'VERT'}, APORegion.Jahr={'2018'}>}Sales_Total/Product_Count)

Here, i'm trying to ignore few selection from, verything works fine apart from FBNum. When there is an FBNum value selected the chart gives me Null Values.

Please, provide me some inputs if we need to use any other strategy to ignore this particular field.

Re: Ignore certain selections in SET Analysis

sunny_talwar — Tue, 27 Mar 2018 13:46:29 GMT

Is there a sample you can share to show the issue?

Re: Ignore certain selections in SET Analysis

psk180590 — Tue, 27 Mar 2018 14:55:41 GMT

Hello Sunny,

For some reson i'm not able to upload the app. I have tried from different browsers but after the upload i get no response. I will try in some other way.

In the mean time i have Screenshots to explain my problem better.

When i select the FB Num as 1 or 2 the Chart doesn't change(which is expected) But, when i select 3 and above it gives me a error as seen in the screen shot.

Thanks and Regards

Sai.

Re: Ignore certain selections in SET Analysis

sunny_talwar — Tue, 27 Mar 2018 14:59:33 GMT

Can you convert this into a straight table and expand the column so that I can see the expression and dimension... don't add any labels to the expression or dimension.

Re: Ignore certain selections in SET Analysis

psk180590 — Tue, 27 Mar 2018 15:08:20 GMT

Re: Ignore certain selections in SET Analysis

sunny_talwar — Tue, 27 Mar 2018 15:10:56 GMT

Very strange, I am not sure I understand the reason behind this.... can we wait until the attachment comes through?

Re: Ignore certain selections in SET Analysis

psk180590 — Tue, 27 Mar 2018 15:13:14 GMT

Yes, this is very strange. I'm trying to upload the sample and hopefully you can check it back soon.

Re: Ignore certain selections in SET Analysis

psk180590 — Tue, 27 Mar 2018 16:11:20 GMT

Hello Sunny,

I just found out the reason for this behaviour.

Say i have 10 Regions in my dashboard and all the Regions have FB Num 1 & 2 upto now. So, when i select 1 or 2 the Bar Chart doesn't respond.

But, if i select 3 or 4 which is only present in few Regions then the Data fails and gives out an error.

I'm not sure if this is the ideal behaviour, but anyways atleast we know the reason.

Thank you for the help. Cheers!!