topic Re: Qliksense Line Graph Formatting in App Development

Qliksense Line Graph Formatting

Simon_Mortimore1 — Wed, 21 Jul 2021 11:40:47 GMT

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?

Re: Qliksense Line Graph Formatting

tresB — Wed, 21 Jul 2021 12:19:41 GMT

Try with dual(), Something like:

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

Number formatting - 'Measure Expression'

Re: Qliksense Line Graph Formatting

Simon_Mortimore1 — Wed, 21 Jul 2021 12:33:03 GMT

Thanks, we will give it a try.

Re: Qliksense Line Graph Formatting

Simon_Mortimore1 — Wed, 21 Jul 2021 13:15:42 GMT

Thanks worked a treat!