Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
rohitians
Creator III
Creator III

Limiting dimension values??

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

1 Solution

Accepted Solutions
rohitians
Creator III
Creator III
Author

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

View solution in original post

2 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

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
Creator III
Creator III
Author

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