Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Set analysis - concatenating

I have the following expression that works fine:

Sum ({<[Incurred Year] = {$(=Max([Incurred Year]))}>}[Car Sales])

However, I need to make it so that the above changes so that the left side of the equation is <[Incurred Year Month] and now the right side needs to still be the max of the Incurred Year field BUT also concatenated with the field [Renewal Month].

In non-Qlikview terms:

[Incurred Year Month] = max([Incurred Year] & [Renwal Month]

3 Replies
chematos
Specialist II
Specialist II

I didn't try but you could use this.Check the MonthDate format is the same that [Incurred Year Month] and the ()...

Sum ({<[Incurred Year Month] = {$(=MonthName(makedate(Max([Incurred Year]),[Renwal Month],1),'MMM/YYYY'))}>}[Car Sales])

hope this helps

zagzebski
Creator
Creator
Author

Thanks for the response. Unfortunately didn't work.

To be clear on the data:

"Incurred Year" is a 4 digit text field (ex 2013)

"Incurred Year Month" is 6 digit text field (ex 201302)

"Renwal Month" is 2 digit text field (ex 02)

chematos
Specialist II
Specialist II

Have you tried to change the format to YYYYMM.

The idea is the next: makedate(2013, 02,01) return a date in your default date format, using MonthName() to that date would return Feb 2013, but you need to get 201302 so we use MonthName( date, 'YYYYMM').

Maybe there is a syntax problem but I think is something like this:

Sum ({<[Incurred Year Month] = {$(=MonthName(makedate(Max([Incurred Year]),[Renwal Month],01),'YYYYMM'))}>}[Car Sales])