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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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