topic Set analysis in chart - unexpected results in QlikView

Set analysis in chart - unexpected results

Wed, 03 Nov 2010 10:43:56 GMT

Morning all,

I have a document where the user wants to be able to define for themselves how many months are to be included in the analysis (1 to 13).

The document creates a set of variables at load time based on the current month. These are then used to create dynamic expressions depending on the number of months selected and I use 'sum' with 'set' to calculate the values.

However, I dont see what I expect to see - please see the comments in the attached qvw.

Is it the way I am trying to use set analysis (I'm afraid me and it are barely on speaking terms) or more fundamental?

Any help appreciated.

Regards,

Gordon

Set analysis in chart - unexpected results

sathishkumar_go — Wed, 03 Nov 2010 13:20:48 GMT

Hi Gordon,

In that Application, Cust5 and 5 don't have values that what pivot is not showing....

-Sathish

Set analysis in chart - unexpected results

Wed, 03 Nov 2010 14:11:32 GMT

Hi Sathish,

...but if the result of the 'set(sum' is 0 and 'suppress zero-values' is NOT checked....?

Regards,

Gordon

Set analysis in chart - unexpected results

Oleg_Troyansky — Wed, 03 Nov 2010 14:25:39 GMT

Gordon,

very strange behavior.. especially when it comes to "Cust4" and "Cust5", when the Dimension value is being replaced with a null()... I'd report it to support as a possible bug.

I don't see any problems in your Set Analysis, it's pretty straight-forward...

Set analysis in chart - unexpected results

Wed, 03 Nov 2010 14:53:46 GMT

Thanks Oleg - I have raised it with support and will post their response.

Regards,

Gordon

Set analysis in chart - unexpected results

Mon, 08 Nov 2010 14:53:02 GMT

...this has been given bug ID 33875

Gordon

Set analysis in chart - unexpected results

Wed, 24 Nov 2010 13:36:54 GMT

I got this reply from Support:

Unfortunately the issue as described below has been rejected by our Test department as a WAD (Works As Designed), ID 33875.

We can however provide you with a workaround which should help you.

This looks to be related to the fact that the Cust4 and Cust5 data is all zero's

if you go to Object > Properties > Dimensions tab and then select the "Show All Values" checkbox then the Cust4 and Cust5 Data appears, and if you Deselect the "Suppress When Value is Null" you will see the Null Value line appear under the other data.

About "Show all Values":

Select this box to show all the dimension field values in the chart, including logically excluded values.

the "Logically Excluded Values" is what i think Cust4 and Cust5 data is.