topic Re: Multiple Months MTD in QlikView

Multiple Months MTD

sanjujeeboy — Sat, 16 Nov 2024 03:38:02 GMT

Hi team,

my requirement is

If we select multiple months eg: if i select Jan Feb Mar 2019 it should compare with Jan Feb Mar 2018 sales

How to achieve this in front end?

Re: Multiple Months MTD

sunny_talwar — Thu, 09 May 2019 10:51:33 GMT

Without knowing how your data looks, it would be difficult to give you an exact response, but may be look into set analysis to do this

Re: Multiple Months MTD

sanjujeeboy — Thu, 09 May 2019 11:20:28 GMT

Hi Sunny,

So i have sales data for 2017 2018 2019....so the requirement here is if the user selects any months eg Apr may June for 2019, i should get data for Apr may june 2018 also(ie last year same months) . If he selects Jan Feb 2018, then the data to show will be Jan Feb 2017.

Can you help on this ? and also if set analysis is to be used how to do that ?

Re: Multiple Months MTD

sunny_talwar — Thu, 09 May 2019 11:25:05 GMT

I sure can try to help.... please share a sample so that I can help you 🙂

Re: Multiple Months MTD

kushalthakral — Thu, 09 May 2019 12:32:22 GMT

In set analysis you can mention Max(Year)-1 which will always show selected year - 1 for the selected months

like example below

Sum({<Year = {$(=Max(Year)-1)}>}Sales)

Thanks

Kushal