Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jim_chan
Contributor III

How to switch different expression in a pivot table?

Hi guys,

I have a pivot table need to create. and have to be very flexible, and i dont know how to do it.

1) The product table by default, it will show Month 1st (Jan - Dec). When i select a Month, it will switch to Day, showing(1-31)

2) The product table by default it will show Quantity expression 1st. Then, When i click on Amount button, it will show Amount instead of Quantity.

I only know it has to play around with "Enable Condition".

how_to_do.png

Rgds,

Jim

8 Replies
Not applicable

Re: How to switch different expression in a pivot table?

You can review this, you'll learn something from it. This qvw is downloadedl from the community from a old post. Iit can apply to pivot table or straight table.

lalitinmbd
New Contributor III

Re: How to switch different expression in a pivot table?

Use a variable to toggle the expression through conditional under Expression Tab..

jim_chan
Contributor III

Re: How to switch different expression in a pivot table?

i managed to toggle Quantity or Amount.

But for the Daily(Day) and Monthly(Month), how to toggle?

i want an outcome as in , when i selected a Month, the pivot table will show me daliy(1-31 days) of that selected month.

When i unselect any Month, that pivot table will show me Monthy(Jan-Dec) .

Rgds

Jim

Re: How to switch different expression in a pivot table?

Hi,

did you check cyclic dimension or drill down dimension??

also search for adhoc reporting

Adhoc reporting in Qlikview

Regards,

Regards,
Prashant Sangle
nizamsha
Valued Contributor

Re: How to switch different expression in a pivot table?

check this one this is the one you want

lalitinmbd
New Contributor III

Re: How to switch different expression in a pivot table?

Use Day in you dimension and cross it below the month field. It will be expanded when you will click on Month and daily data will be visible.

MVP
MVP

Re: How to switch different expression in a pivot table?

For 1

Create a drill down group with Month and Day. That will create the dimension behavior you are looking for.

For 2

Create two expressions with expression conditions using a variable. Set the variable to 1 when clicking the Amount button or 0 when clicking the Quantity button. Use the conditionals for the two expressions:

     =if(vForm = 1, 1, 0)

     =if(vForm = 0, 1, 0)

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

Re: How to switch different expression in a pivot table?

Hi,

Hope this helps

Community Browser