MTD Cal

qlikapple — Sat, 16 Nov 2024 18:07:41 GMT

Hi , I have requirement , Please find the attached qvw

I have data till August Suppose if the user opens the dashboard by default it should show the Previous month-Previousprevious month data

Example: I have august data till august 19th, if the user opens the dashboard I need show the (July data-June data)/June data in the KPI-Vol.

suppose if tomorw the data is till sep20 , if the user opens the dashboard I need show the ( August data-July data)/july data in the KPI-Vol.

Now the Trick part comes here. suppose if the user selects any year and month like may2020, we need to show the current month-previous month data .

Example: if user selects May2020 month. he has to show (May2020 data- April 2020 data)/April data. and

if user selects Apr2020 , he has to show the (Apr2020 data- Mar2020 data)/ Mar data

can anyone please help as it is very urgent .

Please find the attached KPI

VOL = Sum(APPLICATIONS)

Re: MTD Cal

Brett_Bleess — Wed, 23 Sep 2020 11:09:56 GMT

Regards,
Brett

topic Re: MTD Cal in QlikView

MTD Cal

Re: MTD Cal