topic How to split dimention in pivit table in QlikView

How to split dimention in pivit table

Mon, 06 Jun 2016 20:11:17 GMT

Hello there,

The data fields "Month" and "Receipt Type" will be the dimension.

Under "Receipt Type" there are "Initial Receipt" and "Follow up Receipt" two different values. "Initial Receipt" value based on "Initial Receipt Date". "Follow up Receipt" based on "Follow up Receipt Date" . Such as,

Month Receipt Type Initial Receipt Date Follow up Receipt Date

Jan Initial Receipt 01/05/2015 01/08/2015

Feb Initial Receipt 02/05/2015

Mar Follow up Receipt 03/05/2015 03/08/2015

I would like to have the pivit table which can split two values from "Receipt Type" into two columns. Such as,

Month	Receipt Type
Month	Initial Receipt	Follow up Receipt
Jan	1	1
Feb	1
Mar		1

How can I do with the Pivit table to create the one shows above? Am I able to do it?

Thanks in advance,

Becky

Re: How to split dimention in pivit table

sunny_talwar — Mon, 06 Jun 2016 21:06:06 GMT

You will need to create a Canonical Calendar here: Canonical Date

Re: How to split dimention in pivit table

qliksus — Fri, 10 Jun 2016 07:50:21 GMT

If I requirement is very simple as you stated you can also created a Calculated dimension like

Dimension : Month

Dimension : Value list ( 'Initial Recepit' , 'Followup Receoipt')

Exp :if( Value list ( 'Initial Recepit' , 'Followup Receoipt') = 'Initial Recepit' , count(Initial Receipt Date ) , count(Follow up Receipt Date) )