Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lakshmanan
Partner - Contributor III
Partner - Contributor III

Set axes in qlikview chart

Hi , 
I was looking for the possibility to set the axes as month end of the date in Qlikview chart .
something like if Date is 20-Aug -2020 , axes should display 31-Aug-2020 .similar for others to display only monthend date in axes.  In Line chart , if i select dimension axis as continuous , i get the month start for few dates .Can someone please help to get the monthend in axes .

Lakshmanan_1-1757582586461.png

sample axes format to be displayed:

Lakshmanan_2-1757582854924.png

Test file attached .

Labels (3)
13 Replies
Lakshmanan
Partner - Contributor III
Partner - Contributor III
Author

Please find the test.qvf file attached

marcus_sommer

It looked that you didn't apply an aggregation like sum(A) or avg(B) and so on. If there is none and there aren't only unique values - which isn't the case here because there n records for the Sep + Oct - the result will be NULL.

Lakshmanan
Partner - Contributor III
Partner - Contributor III
Author

Sum or Avg is not required in my case, so ,Is there any other possibility to display the conitnuous axis for monthend and show all data points .

marcus_sommer

An aggregation is a must because there exists more as a single value for the 3 Sep record - which seems to be dimensionally adjusted as monthend(). This means the is only a single date available but 3 different values - which one should be shown against this single data-point?

Therefore any logic respectively aggregation is needed to define the return. If sum() and avg() isn't wanted it might be min() or max() ...

It's general topic and independent to the kind of visual and the wanted view - means you would also enforce a NULL if not monthend() is used else pure dates and there are two or more different values for a single date.