Compare values in a chart with different date

[pascos88]

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

[olivierrobin]

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