Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
QSense
Contributor II

Chart , rate

Hi ,

In first chartI have a rate for instance 16 % When I clicked on this rate,

I want to see in second chart the total rate 16% not 100%

How can I do?

Tags (1)
3 Replies
QSense
Contributor II

Chart , rate

rate.png

Partner
Partner

Re: Chart , rate

Hi ,

   You can use Set analysis to capture the total sales figure then find the relative % of the Dimension.

PFA an crude example.

Cheers!

QSense
Contributor II

Chart , rate

Hi

My expression is

Sum(CPN_BSD_BRD_PX)

/

Sum(Total <CalendarDate> CPN_BSD_BRD_PX)

How should I do?