topic Re: Chart ignoring distinct expression when second element is added to stack bar chart in QlikView

Chart ignoring distinct expression when second element is added to stack bar chart

matthewp — Tue, 29 Sep 2015 08:02:59 GMT

I have a simple bar chart which uses two values SID and STATUS.

STATUS is the dimension and the expression is Count(distinct SID).

However i want to add a third value so i can have stacked bar charts.

Re: Chart ignoring distinct expression when second element is added to stack bar chart

Gysbert_Wassenaar — Tue, 29 Sep 2015 08:08:15 GMT

Try adding count(distinct COMP) as second chart expression.

Re: Chart ignoring distinct expression when second element is added to stack bar chart

swuehl — Tue, 29 Sep 2015 08:09:30 GMT

Could you upload a small sample QVW and your expected result? It's unclear to me how your setting / data model looks like and what you are trying to achieve.

Re: Chart ignoring distinct expression when second element is added to stack bar chart

nagarjuna_kotha — Tue, 29 Sep 2015 08:27:17 GMT

Can u share sample application ?

Re: Chart ignoring distinct expression when second element is added to stack bar chart

matthewp — Tue, 29 Sep 2015 09:45:36 GMT

I tried to clean up the comments to make it easier for future use but it deleted your answer which worked perfect!!!

Edit the above and i will mark it as correct...

count(DISTINCT SUPPLIER_ID)*

count(total <STATUS> DISTINCT SUPPLIER_ID)/

sum(total <STATUS> aggr(count(DISTINCT SUPPLIER_ID),STATUS,COMPANY))

Re: Chart ignoring distinct expression when second element is added to stack bar chart

Gysbert_Wassenaar — Tue, 29 Sep 2015 09:49:54 GMT

Please don't clean up discussions like that. The responses may not all have been useful to you, but you can't be sure other people did not find them useful in some way. You also remove all the context and relevant information so nobody can now figure out what the heck this discussion was about in the first place.

Attached is the qvw with a solution.

Re: Chart ignoring distinct expression when second element is added to stack bar chart

tresB — Tue, 29 Sep 2015 10:19:21 GMT

I found this (not really THIS but how it was before deletion) discussion to be one the better discussions. But alas! what you have done. It's hard now to make out the actual requirement you have that was derived after a long chain of discussions. I will try to recollect the problem in my words for future references.

There is a combo chart : Dim1: STATUS Expression: Count(Distinct SUPPLIER_ID)

This gives distinct counts STATUS wise.

Now second dimension : Company is added to get stacked bars which would break up the distinct counts (that was coming STATUS wise) into Company and NOT distinct Company wise. I.e. - the total distinct count should match the number that comes STATUS wise (with no Company dimension). If the expression - Count(Distinct SUPPLIER_ID) is used, count() decides dintinction on Company as well, and that is not desired.

This will help me understand the case when I revisit this thread which I bookmarked. Please don't clean-up this even if you find this not really helpful.

Re: Chart ignoring distinct expression when second element is added to stack bar chart

kamielrajaram — Tue, 29 Sep 2015 10:45:15 GMT

Hi,

Maybe try this in your expression

Count(total <STATUS> DISTINCT SUPPLIER_ID)/
count(total <STATUS> distinct COMPANY)