Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart with a drill-down group containing three expressions of a timestamp
year(timestamp), month(timestamp), day(timestamp)
When the lowest level (day) is shown in the chart I want year and month in the title. Some posts here use dimensionality to test what level is shown, but that does not seem to work in a chart.
Is there another way to know what level of the drill down group is shown ?
To determine in title, i think you must derive based on possible count, mimicking what the drill down does.
if(count(distinct year(timestamp)) >1, 'year',
if(count(distinct month(timestamp)) >1, 'month',
year(timestamp) & month(timestamp)
))
For QlikView, you should be able to use GetCurrentField(Groupname) to find out which field is currently active in the group.
To determine in title, i think you must derive based on possible count, mimicking what the drill down does.
if(count(distinct year(timestamp)) >1, 'year',
if(count(distinct month(timestamp)) >1, 'month',
year(timestamp) & month(timestamp)
))
That does not seem to work because it is a calculated field.