Display in a chart only latest values

Thu, 14 May 2009 02:02:50 GMT

Hello everybody !

I would like, in a chart, only to display the latest values.
Let me develop

for instance i've values on a timescale divided in quarters, and those values are from 2005 Q1 to 2009 Q4.
When i want to see them on a chart (let's say a line one), i see all values.

Is it possible to ONLY display the latest values through QlikView WITHOUT SetAnalysis (if possible) ?
Indeed, a solution somebody gave me was to hide some values, however, when there's a huge difference between values, the whole axis takes into account the greatest value...

For instance, in 2005 you've 200.000 (you don't want to display) and in 2009, you've 5.000.
If you hide, the chart will consider as greatest value 200.000 ...
I would like the chart to take into account ONLY the values after 2008 and , so, if the greatest value in this dataset is 15.000, the chart MUST use 15.000 as the maximum value...

Thanks 😉

Display in a chart only latest values

johnw — Thu, 14 May 2009 02:15:38 GMT

I'm not sure I understand your definition of "latest value". Still, I can think of a few approaches if you mean the values by quarter for the most recent year. You could handle it in the chart expression by doing something like sum(if(Year=max(total Year),Sales)). You could handle it in the chart dimension by doing something like if(Quarter>=max(total Year),Quarter), then suppressing the dimension when null (assuming both Quarters and Years are defined as begin dates, which is what I do). Or you can just have the user select the current year. Or you can select it for them in an OnOpen macro.

If I'm not understanding what you want, please clarify. Thanks.

topic Display in a chart only latest values in QlikView

Display in a chart only latest values

Display in a chart only latest values