topic Re: Relative display in Pivot in QlikView

Relative display in Pivot

dafnis14 — Mon, 28 Mar 2016 05:08:04 GMT

Hi,

I Have created a pivot table with 4 dimensions.

The relative expression is :

sum( [# of Seats/Rooms])/Sum( TOTAL <[ServDay of week], RsvServiceDate > [# of Seats/Rooms])

when selecting a value for the first dimension, relative results work fine:

When all dimension values are displayed, the relative does not accumulate to 100%:

Any idea how i should fix this?

Thanks!

Re: Relative display in Pivot

Chanty4u — Mon, 28 Mar 2016 05:34:11 GMT

will u able to share sample app/

Just un-tick relative for all expressions
Check the number format to be as per your requirement.

Re: Relative display in Pivot

ahammadshafi — Mon, 28 Mar 2016 05:36:03 GMT

May be this will work

sum( <[Location]>[# of Seats/Rooms])/Sum( TOTAL <[ServDay of week], RsvServiceDate > [# of Seats/Rooms])

Ahammad Shafi

Re: Relative display in Pivot

avinashelite — Mon, 28 Mar 2016 05:39:04 GMT

Try like this

sum( [# of Seats/Rooms])/Sum( TOTAL <Location,[ServDay of week], RsvServiceDate > [# of Seats/Rooms])

Re: Relative display in Pivot

dafnis14 — Mon, 28 Mar 2016 06:36:43 GMT

Hi,

Thanks, but there seems to be a syntax issue....

Re: Relative display in Pivot

dafnis14 — Mon, 28 Mar 2016 06:38:10 GMT

Hi,

I tried it, but it doesn't change the result...

Thanks!

Re: Relative display in Pivot

dafnis14 — Mon, 28 Mar 2016 06:38:50 GMT

Hi,

It's a pivot table, so Relative option is not available...

Thanks!

Re: Relative display in Pivot

ecolomer — Mon, 28 Mar 2016 06:54:02 GMT

Try this:

sum( <[Location]=>[# of Seats/Rooms])/Sum( TOTAL <[ServDay of week], RsvServiceDate > [# of Seats/Rooms])

Re: Relative display in Pivot

dafnis14 — Mon, 28 Mar 2016 07:11:03 GMT

Sorry Avinash,

I picked the wrong field..

You were right..

Thanks!

Re: Relative display in Pivot

avinashelite — Mon, 28 Mar 2016 07:45:38 GMT

Cool