Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jasmina_karcic
Contributor II

X-axis doesn't show all values (date axis)

Hi everyone,

I need to show data values, for last 8 weeks, or 12 last months. I make in properties "fixed number" and 8 and top. But Qlik Sense doesn't give me what I need

I need it shows to me x-axis with values (end of weeks):

6.5., 13.5., 20.5., 27.5.,3.6, 10.6., 17.6., 24. 6.

It is missing some values.

1pg.png

2pg.png

I cannot understand what is problem, like it puts randomly values.

sedmica.png

ZadnjiDanSedmica is defined in Data load editor:    if (date(DATUM) = Floor(weekEnd(DATUM)),DATUM) as ZadnjiDanSedmica

DATUM is date.

Thanks

5 Replies
niclaz79
Contributor III

Re: X-axis doesn't show all values (date axis)

Hi, this happens when you don't have data on all dates. Qlik will summarize over all versions of the dimension (date) that is in the data set.

If you have a complete calendar a good practice is to add an additional expression that shows all dimension values, for example:

Only({1<Year = {$(=Max(Year))}>}Week)  will show all weeks in the current selected year (or highest year if no year is selected).

This is how I normally sort out situations like this.

jasmina_karcic
Contributor II

Re: X-axis doesn't show all values (date axis)

Can you show me this on example?

Thanks

jasmina_karcic
Contributor II

Re: X-axis doesn't show all values (date axis)

I have values for all dates stanja.png

imhappiee
New Contributor III

Re: X-axis doesn't show all values (date axis)

hi

I guess the top 10 is getting applied on values ,based on the values you are trying to pull the date, so you might be missing some dates, Just try to play with it, You should get it .

Anand

jasmina_karcic
Contributor II

Re: X-axis doesn't show all values (date axis)

With Qlik is always palying.