Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

millywalters
New Contributor

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
millywalters
New Contributor

Re: Merge Results of Dimensions in If Statement

Thank you. Did you get some answer for me?

Community Browser