topic Re: Stacked chart hover over issue in QlikView

Stacked chart hover over issue

mayankraoka — Tue, 08 Dec 2015 08:43:01 GMT

Hi Team,

Is it possible in stacked chart to hover over all the values of 2nd dimension at one go?If yes then how it can be done?

I have used 2 dimension for ex.month and category and 2 expressions(used as cyclic)

Please let me know in case of any other information required.

Regards,

Mayank

Re: Stacked chart hover over issue

Gysbert_Wassenaar — Tue, 08 Dec 2015 16:39:49 GMT

I think that's possible. Disable the Pop-up labels option on the presentation tab. Enable the Text as Pop-up options for the expressions. And change the expressions from something like sum(Sales) to something like

dual(Concat(total <Dimension1> distinct Dimension2 & ': ' & num(aggr(nodistinct sum(Sales),Dimension2,Dimension1),'#,##0') , chr(10)),

sum(Sales)

)

Replace Dimension1 and Dimension2 with the dimensions of your bar chart.

Re: Stacked chart hover over issue

mayankraoka — Wed, 09 Dec 2015 05:59:51 GMT

Hi Gysbert,

Thank you very much for your reply.In simple expression this works checked.But in my case expression is not considering all the values of dimension2. Please refer below is my expression:

expression:

sum({<CATEGORY={'repeat','begin','win','lose' },MonthName=,MonthID ={'<$(=$(vLast12Month))'}>}LRx_L)/sum(TOTAL<MonthName> {<CATEGORY={'repeat','begin','win','lose'},MonthName=,MonthID ={'<$(=$(vLast12Month))'}>}LRx_L)

When I used your suggested solution i looks like this:

dual(Concat(total <MonthName> distinct CATEGORY & ': ' & num(aggr(nodistinct sum({<CATEGORY={'repeat','begin','win','lose' },MonthName=,MonthID ={'<$(=$(vLast12Month))'}>}LRx_L)/sum(TOTAL<MonthName> {<CATEGORY={'repeat','begin','win','lose'},MonthName=,MonthID ={'<$(=$(vLast12Month))'}>}LRx_L),CATEGORY,MonthName),'#,##0') , chr(10)),

)

But did not get hover over on this?

Can you please help

Regards,

Mayank

Re: Stacked chart hover over issue

Gysbert_Wassenaar — Wed, 09 Dec 2015 18:42:34 GMT

Can you create a small qlikview document that demonstrates the problem?

Maybe this document helps: Preparing examples for Upload - Reduction and Data Scrambling

Re: Stacked chart hover over issue

mayankraoka — Thu, 10 Dec 2015 09:55:27 GMT

Hi Gysbert,

Please find attached reduced app for your reference:

Please let me know in case of any other information required.

Regards,

Mayank