Expression on one field, but retrieve another field

[mikevmalta]

Hi,

Is there a way in QlikView, where you calculate an expression on one field, but then display another field?

i.e. I have a project, which has a starting date and a name for the one responsible. I want to create a line chart, where the values are based on the number of days passed from the start of the project, but display the names on the value points (instead of the number of days). Is this possible?

Thanks in advance!

Michael

[Gysbert_Wassenaar · Accepted solution]

You can probably ise the dual function to create a value with both a text and numeric value: dual(ProjectName, nr_of_days_passed)

[mikevmalta]

Hi Gysbert,

Thanks a lot mate worked perferctly!!