Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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

6 Replies
Highlighted
Partner
Partner

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.

Highlighted
Creator III
Creator III

Can you show me this on example?

Thanks

Highlighted
Creator III
Creator III

I have values for all dates stanja.png

Highlighted
Contributor III
Contributor III

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

Highlighted
Creator III
Creator III

With Qlik is always palying.

Highlighted
Contributor
Contributor

Hello, Can you please post the solution?