topic Pivot Table in QlikView

Pivot Table

soha1902 — Fri, 10 Oct 2014 05:57:22 GMT

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.

Re: Pivot Table

soha1902 — Fri, 10 Oct 2014 06:12:33 GMT

Any suggestions Please?

Re: Pivot Table

jonathandienst — Fri, 10 Oct 2014 06:16:42 GMT

Use a calculated dimension for State:

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

See attached

HTH

Jonathan

Re: Pivot Table

PrashantSangle — Fri, 10 Oct 2014 06:19:15 GMT

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