Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

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

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
Partner - Contributor III
Partner - Contributor III

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

jim_chan
Specialist
Specialist
Author

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,

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 🙂
nizamsha
Specialist II
Specialist II

check this one this is the one you want

lalitinmbd
Partner - Contributor III
Partner - Contributor III

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
Partner - Champion III
Partner - Champion III

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
Creator III
Creator III

Hi,

Hope this helps