Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using field value in table expression

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Expression:

=$(=Formula)

PFA

View solution in original post

9 Replies
vijetas42
Specialist
Specialist

Hi,

Can you explain more what exactly you want to do?

Not applicable
Author

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

Not applicable
Author

can anyone sugeest any method to do so..

Regards,

Prajna

tresesco
MVP
MVP

Expression:

=$(=Formula)

PFA

vijetas42
Specialist
Specialist

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.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

=$(Only(Formula))


Note : Selection of Name is mandatory.


Hope this helps you.


Regards,

Jagan.

shambhub
Creator
Creator

Hi,

Try this below expression, it works 100%

=$(=F1)

Not applicable
Author

Thanku

Regards,

Prajna

Not applicable
Author

Thanku All

Regards,

Prajna