Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Merge Results of Dimensions in If Statement

I would like to show the whole FY17TD(should include Jul2017)

But would also like to show Current Month JUL2017.

My script excluded July ,

How can I have it add JULY TO FY17TD?

if(

match([LATEST_START_DATE.Calendar.YearMonth],'2016/Oct', '2016/Nov','2016/Dec','2017/Jan', '2017/Feb', '2017/Mar', '2017/Apr', '2017/May', '2017/Jun', '2017/Jul', '2017/Aug', '2017/Sep')

,'FY17TD',

if(

[LATEST_START_DATE.Calendar.YearMonth] = '2017/Jul', 'Month', 'FY17TD'

)

)

I am presenting 20 DIFFERENT KPIs on my PIVOT Table and I need the two Categories!

1 Reply
Anonymous
Not applicable
Author

Thank you. Did you get some answer for me?