Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.