Qliksense Line Graph Formatting

[Simon_Mortimore1]

Hi,

We are presently using QS to automate our Board Integrated Performance Report and have a formatting challenge.

One of the graphs is a line one that shows demand (we are a 999/911/112 ambulance service). It shows the current year and the past two years for comparator purposes.

The current year has labels on the data point, but we do now want to show the labels for previous years.

Any ideas how to do this?

[tresesco · Accepted solution]

Try with dual(), Something like:

=Dual(If(Year(Date)=Year(Today()),Sum(Data) ,''), Sum(Data))

Number formatting - 'Measure Expression'

[Simon_Mortimore1]

Thanks, we will give it a try.

[Simon_Mortimore1]

Thanks worked a treat!