Compare values in a chart with different date

pascos88 — Mon, 26 Mar 2018 06:56:39 GMT

Hello,

I need to create a chart to compare values with different date.

Some values have as a date DD.MM.2016 and ather values date as DD.MM.207.

Now I need to compare this value without considering tha YYYY, but just considering DD and MM.

I tried already to put in load the data as date(floor(DATE),'DD.MM') as day and use this Day in the chart, but still looks that qlik doesn't recognize just tha day, but in the chart I have before all the date from 2016 and later all the data from 2017..

1) Some ideeas?

2) also in the in the load of the data I have all date,how I can show all the date in the chart, even if there is no value in that date? I mean if there is no count in the date 22.05.2016 I would see this date in the chart.

Using QS

Thanks for any help

Re: Compare values in a chart with different date

olivierrobin — Mon, 26 Mar 2018 07:11:20 GMT

hello

1) why don't you use 2 dimensions : 1 for day, 2nd for year

2) you have to create a list of all dates on another table, then use this dimension ion your graph

topic Compare values in a chart with different date in QlikView

Compare values in a chart with different date

Re: Compare values in a chart with different date