topic Re: Need Help on using concatenated output in QlikView

Need Help on using concatenated output

rangam_s — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Need Help on using concatenated output

sunny_talwar — Tue, 12 Jun 2018 16:59:53 GMT

What exactly is the problem that you are facing?

Re: Need Help on using concatenated output

rangam_s — Wed, 13 Jun 2018 04:35:12 GMT

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.

Re: Need Help on using concatenated output

sunny_talwar — Wed, 13 Jun 2018 15:54:08 GMT

So, what is the problem?

Re: Need Help on using concatenated output

rangam_s — Thu, 14 Jun 2018 11:53:17 GMT

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

Thanks

Re: Need Help on using concatenated output

rangam_s — Mon, 18 Jun 2018 05:12:50 GMT

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

I got expected results with the above logic.