Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
sample axes format to be displayed:
Test file attached .
Please find the test.qvf file attached
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.
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 .
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.