topic Expression on one field, but retrieve another field in QlikView

Expression on one field, but retrieve another field

mikevmalta — Wed, 08 May 2013 12:08:05 GMT

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

Re: Expression on one field, but retrieve another field

Gysbert_Wassenaar — Wed, 08 May 2013 12:11:53 GMT

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

Re: Expression on one field, but retrieve another field

mikevmalta — Wed, 08 May 2013 12:37:43 GMT

Hi Gysbert,

Thanks a lot mate worked perferctly!!