Pivot table

Thu, 27 Feb 2014 14:47:28 GMT

Hi all,

I got 2 short questions:

1 - I build myself a pivot table containing information about Revenue and Shipments.

Dimensions = weekday

= Weeks

Now I would like to be able switching between Revenue and Shipments. It now shows me the info next to each other Revenue and Shipments.

I want it to only show me Revenue but when I clikc a button or something to switch to shipments.

Start using buttons and conditional??

2 - I would like to add a 3th expressions containing the percentages per day of the week total like:

monday 20%

tuesday 10%

etc etc 100%

now i got sum(revenue)/sum(total(reveneu) but then it shows me 1% per day and all the days collected it gives me 100%. I would like to add to 100% per week and not over all the weeks.

kind regards

Re: Pivot table

marcus_sommer — Thu, 27 Feb 2014 14:52:45 GMT

1. You could use groups for dimensions/expressions and/or use visibilty-conditions for them - perhaps per button.

2. Try: sum(total <Week> reveneu)

- Marcus

Re: Re: Pivot table

MK_QSL — Thu, 27 Feb 2014 15:10:06 GMT

Something like this?

topic Re: Pivot table in QlikView

Pivot table

Re: Pivot table

Re: Re: Pivot table