topic Re: Quarter Field Values should be First,second in QlikView

Quarter Field Values should be First,second

Mon, 12 Nov 2012 19:37:43 GMT

Hi community members,

Is their any way to represent the Quarter field values First, Second, Third and Fourth

instead of 1,2,3,4, can one help me please

Regards,

ramesh

Mon, 12 Nov 2012 19:42:05 GMT

Create a mapping table to map values 1,2,3,4 as First, Second, Third and Fourth and use the applymap to use in your main transaction table.

Mon, 12 Nov 2012 19:47:54 GMT

If it is just in a list box for aesthetic purposes, you can use the Dual() function:

Dual(
if(Quarter='Q1','First',
if(Quarter='Q2','Second',
if(Quarter='Q3','Third',
if(Quarter='Q4','Fourth')))),Quarter

)

Then you can sort using Match()

its_anandrjs — Mon, 12 Nov 2012 19:49:07 GMT

Hi,

Create another field some thing like

if('Q' & Ceil(Month(Date) / 3) = 'Q1','First',

if('Q' & Ceil(Month(Date) / 3) = 'Q2','Second',

if('Q' & Ceil(Month(Date) / 3) = 'Q3','Third',

if('Q' & Ceil(Month(Date) / 3) = 'Q4','Fourth',

)))) as NewQuarter,

HTH

Regards,

Anand

Mon, 12 Nov 2012 20:04:54 GMT

can you please give the sample example of mapping, I am unware of the mapping function