More than 1 calculate dimension -Pivot Table

helen_pip — Wed, 19 Sep 2012 07:39:28 GMT

Hello,

I was wondering if someone can help me

I have built a pivot table which consists of 4 expressions: Median,Fractile,Longest Time and Over 6 hours

1 Dimension: MonthYear

1 Calculated Dimension: =IF([Patient Admitted?]=1, 'Admitted', 'Non-Admitted')

I have used a calculated dimension so that I can split the Median and Fractile between "Admitted" or Non Admitted"

I now need to have another option which is both admitted and non-admitted added together as "Total", but am not sure whether I need to add another calculated dimension or my existing calculated dimension needs amending

Thanks

Helen

Re: More than 1 calculate dimension -Pivot Table

Wed, 19 Sep 2012 07:43:04 GMT

Hi helen,

You can use partial sum options in pivot table presentacion tab, select the dimension and check this option.

I hope to help you.

topic More than 1 calculate dimension -Pivot Table in QlikView

More than 1 calculate dimension -Pivot Table

Re: More than 1 calculate dimension -Pivot Table