Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Adinarayana
Contributor II
Contributor II

Chart Dimension

Hi All I have data like below

Period

Q1-Jan

Q1-Feb

Q1-Mar

Q2-Apr

Q2-May

Q2-Jun

Q3-Jul

Q3-Aug

Q3-Sep

Q4-Oct

Q4-Nov

Q4-Dec

 

i have measure sales

but in chart i need to show only Q1-Jan ,Q2-Apr,Q3-July,Q4Oct

i dont want to show all dimension values in chart any idea

 

 

Labels (1)
1 Reply
MayilVahanan

HI @Adinarayana 

Try like below

Dim: If(Match(Period, 'Q1-Jan' ,'Q2-Apr','Q3-July','Q4-Oct'), Period)

and uncheck include null values.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.