topic Limiting dimension values?? in QlikView

Limiting dimension values??

rohitians — Mon, 07 Oct 2013 07:23:47 GMT

Hello,

I have total receipts and total values,

i am using YearMonth as dimension it starts from Aug-08 but i want it to start from Apr-12, means the list should start from Apr-12

what would be the condition where in i should use this condition??

Thanks and Regards,

Rohit Yadav

bbi_mba_76 — Mon, 07 Oct 2013 07:29:08 GMT

Hi,

in a chart you could use a calculated dimension (like if(YearMonth>'Apr-12', YearMonth) ) or dimension limits to have the last values.

rohitians — Mon, 07 Oct 2013 07:53:54 GMT

Hello,

I was using the same it wasnt working,

I used If(YearMonth>= 41000,YearMonth)

and it is working I used the num(Apr-12) used the value...

Thanks for reply..

Thanks and Regards,

Rohit