Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

rangam_s
Contributor II

Need Help on using concatenated output

Hi All,

I am using aggregation function to generate the maximum transaction date in each month and concatenating it to populate the list of available maximum date.

Background: I have a cumulative data set wherein all the sales will be accumulated till the maximum invoice date in that particular month. Now, I need to populate the sales quantity for each month.

vlistofMaxDates=concat(aggr(max([Invoice Date]),YearMonth) ,',')

if(sum(Match([Invoice Date],$(vlistofMaxDates)))=>1,[Sales Quantity])

Note: Month end is not the maximum date in every-month and not every Maximum transaction date in that month has maximum sales. I using this as chart measure.

Please help me in resolving this issue.

1 Solution

Accepted Solutions
rangam_s
Contributor II

Re: Need Help on using concatenated output

Sum({<[Invoice Date]={$(=$(vlistofMaxDates))}>}[Sales Quantity])


I got expected results with the above logic.

5 Replies
MVP
MVP

Re: Need Help on using concatenated output

What exactly is the problem that you are facing?

rangam_s
Contributor II

Re: Need Help on using concatenated output

I have the cumulative MTD data with invoice dates, wherein I need to show the data for all the selected year months as Line/Bar chart.

MVP
MVP

Re: Need Help on using concatenated output

So, what is the problem?

rangam_s
Contributor II

Re: Need Help on using concatenated output

I was not getting the results for the above, however I have the answer now.

Thanks

rangam_s
Contributor II

Re: Need Help on using concatenated output

Sum({<[Invoice Date]={$(=$(vlistofMaxDates))}>}[Sales Quantity])


I got expected results with the above logic.

Community Browser