Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Can you create a small qlikview document that demonstrates the problem?
Maybe this document helps: Preparing examples for Upload - Reduction and Data Scrambling
Hi Gysbert,
Please find attached reduced app for your reference:
Please let me know in case of any other information required.
Regards,
Mayank