topic Re: Rolling YTD in QlikView

Rolling YTD

stephane_kosior — Sat, 16 Nov 2024 00:59:55 GMT

Hi,

I would like to a YTD calculation each month instead of having the % of each month ..

Thanks

Taoufiq_Zarra — Mon, 23 Mar 2020 11:07:09 GMT

can you develop and share a sample data ?

stephane_kosior — Mon, 23 Mar 2020 11:19:00 GMT

I can't share data as they are confidentials.

Let's say that :

SQL

Select

Date_Payment

,Case When Date_Payment > Date_Due Then 'Late' else 'OnTime' END as Payment_Status

FROM

maTable;

Brett_Bleess — Tue, 14 Apr 2020 21:11:49 GMT

Check the following Design Blog post, may give you some ideas:

Regards,
Brett