Solved: Pivot Table - Qlik Community

soha1902 · ‎2014-10-10

Hi Everyone,

I am using one slider and one pivot table in my Dashboard. My requirement is If user select 3 in slider then chart will show only first three States in chart. Please find sample qvw in attachment. Please suggest.

jonathandienst · ‎2014-10-10

Hi

Use a calculated dimension for State:

=Aggr(If(Rank(Sum(Sales)) <= vSlider, State), State)

See attached

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

soha1902 · ‎2014-10-10

Any suggestions Please?

jonathandienst · ‎2014-10-10

Hi

Use a calculated dimension for State:

=Aggr(If(Rank(Sum(Sales)) <= vSlider, State), State)

See attached

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

PrashantSangle · ‎2014-10-10

Hi,

Try this logic and develop your report

You have to use Rank() in dimension to show row as per selection in slider

In your Slider when user select any value that value set to variable and you have to use that variable in

Rank() to limit rows.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Pivot Table

Related Topics