Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change y-axis in line chart by dual fields

Hi all,

I am using a dimension stored as dual to show an athlete's result on a specific date. This Result field looks like:

test.png

These numbers are used to make a line chart to plot an athelte's result on a specific date. This line chart shows the results with the num(Result) on the y-axis, like this:

test2.png

Note: This image contains results of 2 persons. I want to be able to select 1 person, which means that the y-axis will change when selecting a person.

However, I don't want to see the num(Result) here. Instead I want to see the text(Result). I tried to adjust the number format settings in the object, but changing this to a time format is not flexibel for displaying time in ss.ff (seconds) and time in mm.ss.ff (minutes).

So my question is: How can I adjust the format on the y-axis to text(Result) and making this format flexible between time in seconds and time in minutes?

I have attached a Qlikview document as an example, where Person A's time need to be shown in minutes, and Person B's time in seconds.

Thanks in advance!

Vincent

0 Replies