topic Re: Set graph to start on specific date in QlikView

Set graph to start on specific date

jp_afc — Mon, 26 Jun 2023 08:52:28 GMT

I have data that starts from 01/03/2014 but I want my line graph to start from 01/01/2020 to current date, how would I do this?

I want to create a line graph showing number of incidents that occurred each day start from 01/01/2020

Re: Set graph to start on specific date

NiTo — Mon, 26 Jun 2023 09:06:42 GMT

Hi Jp,

Interesting question. I would also like to see the answer for this one. Hope you get a reply soon.

Re: Set graph to start on specific date

Zapparoli — Mon, 26 Jun 2023 12:29:05 GMT

Hello Jp_afc,

In this case, you have some options.

The first one is working on your measure. You can specify a set Analysis with a data range >= than 01/01/2020 inside your measure, this will make only date greater than 01/01/2020 to appear on your chart.

You can also create a new dimension in the script like:

if(My_Date_Field < 01/01/2020, null(), My_Date_Field) as New_Date_Field.

Personally I would work on my measure instead of going to script on this one.

Hope this helps.

-Zapparoli

Re: Set graph to start on specific date

jp_afc — Mon, 26 Jun 2023 13:01:30 GMT

Perfect. Thank you for your help using the set analysis method worked.