Stacked chart hover over issue

[mayankraoka]

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

[Gysbert_Wassenaar]

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.

[mayankraoka]

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)),

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

)

But did not get hover over on this?

Can you please help

Regards,

Mayank

[Gysbert_Wassenaar]

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

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

[mayankraoka]

Hi Gysbert,

Please find attached reduced app for your reference:

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

Regards,

Mayank