topic Re: Using field value in table expression in QlikView

Using field value in table expression

Tue, 19 May 2015 06:15:11 GMT

hello...

I have a formulas in my table.I want to use those in the expression of my chart..How can i use that..its is not considering it as exression rather its is considering as simple text.

eg:

Name Formula

Total sales sum(sales)

Avg sale avg(sales)

Regards,

Prajna

Re: Using field value in table expression

vijetas42 — Tue, 19 May 2015 06:21:18 GMT

Hi,

Can you explain more what exactly you want to do?

Re: Using field value in table expression

Tue, 19 May 2015 06:27:11 GMT

hi,

Actually i am storing set of formulas that is entered by user, as mentioned above in a table.

Now when user select name that particular formula must be applied in the chart.

say if i select total sales..In chart expression sum(sales) must be applied.If user select name as average sale avg(sales) formula must be selected.

Regards,

Prajna

Re: Using field value in table expression

Tue, 19 May 2015 06:39:03 GMT

can anyone sugeest any method to do so..

Regards,

Prajna

Re: Using field value in table expression

tresB — Tue, 19 May 2015 06:44:05 GMT

Expression:

=$(=Formula)

PFA

Re: Using field value in table expression

vijetas42 — Tue, 19 May 2015 06:46:45 GMT

Hi,
As per my understanding ,you can load names as inline and in chart you can put both the expression and make them conditional as =GetFieldSelection (inline_Field_name)='Total Sales' likewise for Avg.

Re: Using field value in table expression

jagan — Tue, 19 May 2015 06:52:25 GMT

Hi,

Try like this

=$(Only(Formula))

Note : Selection of Name is mandatory.

Hope this helps you.

Regards,

Jagan.

Re: Using field value in table expression

shambhub — Tue, 19 May 2015 07:03:12 GMT

Hi,

Try this below expression, it works 100%

=$(=F1)

Re: Using field value in table expression

Tue, 19 May 2015 07:33:03 GMT

Thanku

Regards,

Prajna

Re: Using field value in table expression

Tue, 19 May 2015 07:33:35 GMT

Thanku All

Regards,

Prajna