topic YTD and MTD Function Not working in QlikView

YTD and MTD Function Not working

Purushothaman — Mon, 05 Jul 2021 09:46:14 GMT

Hi Experts,

Attached is my QVW. I am creating Period comparison, I have created variables to calculate YTD and MTD but still not working. Please help me to resolve it.

Thank you,

Re: YTD and MTD Function Not working

MayilVahanan — Mon, 05 Jul 2021 10:02:40 GMT

Hi Try like attached file.

Changes:

O/P:

Re: YTD and MTD Function Not working

Purushothaman — Mon, 05 Jul 2021 10:22:16 GMT

Hi @MayilVahanan,

Thanks for your quick help. I have downloaded your edited superstoremaster QVW, I saw only changes made in vMaxMonth but I cant see any values like yours. Below is my screenshot image.

Can you please help me to identify the problem.

Thank you

Re: YTD and MTD Function Not working

MayilVahanan — Mon, 05 Jul 2021 10:34:10 GMT

Hi

For me, its working fine. Might be, QV version different. Instead of single quotes in order date, can you try with double quotes like below and change the variable with date format

Re: YTD and MTD Function Not working

Purushothaman — Mon, 05 Jul 2021 10:43:13 GMT

@MayilVahanan Awesome. Thank you very much for your great help.