Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Simon_Mortimore1
Luminary
Luminary

Qliksense Line Graph Formatting

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?

 

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try with dual(), Something like:

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

Number formatting - 'Measure Expression'

View solution in original post

3 Replies
tresesco
MVP
MVP

Try with dual(), Something like:

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

Number formatting - 'Measure Expression'

View solution in original post

Simon_Mortimore1
Luminary
Luminary
Author

Thanks, we will give it a try.
Simon_Mortimore1
Luminary
Luminary
Author

Thanks worked a treat!