topic Re: How to use field value as chart expression in QlikView

How to use field value as chart expression

jagannalla — Thu, 06 Mar 2014 09:23:22 GMT

Hi,

I want to convert my chart expression into field value. How can I plot field value as chart expression ?

For eg:

I've data in the below format

LOAD

* INLINE

[
Val
10
20
30
]

;

LOAD

* INLINE

[
Dim1, Expression
G1, Min(Val)
G2, Max(Val)
]

;

- Now in straight table I'll add Dimension as Dim1.

- In expression I need the expression what we had for each dimension value.

G1 - Min(Val)

G2- Max(Val)

- I know that we can put if condition in expression tab as =If(Dim1 ='G1',Min(Val),Max(Val)), but I don't want to control in expression tab. I want to control using field value i.e. the value of field will be expression.

How can I do this.

Thanks,

Jagan

Re: How to use field value as chart expression

MK_QSL — Thu, 06 Mar 2014 09:44:20 GMT

Like this ?

Re: How to use field value as chart expression

jagan — Thu, 06 Mar 2014 10:32:03 GMT

Hi,

Try this

Regards,

Jagan.

Re: How to use field value as chart expression

jagannalla — Thu, 06 Mar 2014 11:12:43 GMT

But Min and Max value is giving wrong answer

Re: How to use field value as chart expression

jonathandienst — Thu, 06 Mar 2014 11:27:05 GMT

Use Dim1 as the chart dimension and $(=Expression) for the chart expression.

HTH

Jonathan

Re: How to use field value as chart expression

jagannalla — Thu, 06 Mar 2014 13:15:08 GMT

I had used this exp right now

= Pick(Rno,Min(Val),Max(Val))

It is working, but how to control using field value.

Jonatham - I already tried it but no use.

Re: How to use field value as chart expression

anlonghi2 — Tue, 03 Nov 2015 17:47:45 GMT

Hi Jagan,

try this approach:

define a variable named f_Formulas containing the expression =concat(Expression,',')
define a pivot defining Dim1 as dimension and =pick(if(Dim1='G1',1,2), $(f_Formulas)) as expression

Let me know.

Best Regards

Andrea

Re: How to use field value as chart expression

rjyadav94 — Sun, 28 Apr 2019 14:48:53 GMT

Can you please upload the expression because due to my personal edition i am not able to open the qvw files