Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

want to display the graph in year - current day format

I want to display the current year-date graph data This is the code that shows the unmodified graph

Paknanarn23_1-1678937879945.pngPaknanarn23_2-1678937904928.png

And the picture below is what I want, framed in red

Paknanarn23_0-1678937782985.png

 

1 Reply
marcus_sommer

Displaying results with a mixed granularity is possible with a "classical" dimension but not overlapping values like the months and the YTD of 2023 are. A way to create such objects may be not to use a (calculated) dimension else n expressions (for each bar one) by labeling them appropriate as well as the needed set analysis conditions. Even by 15 expressions (3 years + 12 months) the efforts are moderate because the most could be done per copy & paste and just the labels and conditions needs an adjustment.

If it's not a single view else such logic is wanted for multiple views it would be better to transfer the logic into the data-model and using nativ dimensions for such requirements. These dimensions could be created with a logic like:

 The As-Of Table - Qlik Community - 1466130