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

How to switch different expression in a pivot table?

jim_chan — Tue, 19 Jul 2016 03:20:59 GMT

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

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

Tue, 19 Jul 2016 03:34:53 GMT

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.

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

lalitinmbd — Tue, 19 Jul 2016 04:18:41 GMT

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

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

jim_chan — Tue, 19 Jul 2016 05:51:53 GMT

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?

PrashantSangle — Tue, 19 Jul 2016 06:06:48 GMT

Hi,

did you check cyclic dimension or drill down dimension??

also search for adhoc reporting

Adhoc reporting in Qlikview‌

Regards,

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

nizamsha — Tue, 19 Jul 2016 06:49:30 GMT

check this one this is the one you want

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

lalitinmbd — Tue, 19 Jul 2016 11:10:28 GMT

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.

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

jonathandienst — Tue, 19 Jul 2016 11:32:07 GMT

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)

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

kamielrajaram — Tue, 19 Jul 2016 12:02:19 GMT

Hi,

Hope this helps