How to switch different expression in a pivot table?

[jim_chan]

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".

Rgds,

Jim

[#2]

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]

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

[jim_chan]

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

[PrashantSangle]

Hi,

did you check cyclic dimension or drill down dimension??

also search for adhoc reporting

Adhoc reporting in Qlikview‌

Regards,

[nizamsha]

check this one this is the one you want

[lalitinmbd]

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.

[jonathandienst]

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)

[kamielrajaram]

Hi,

Hope this helps