Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
blednyi
Partner - Contributor II
Partner - Contributor II

Field value treated like expression

Hi !

I'm trying to do chart where expression is read in certain field. Why I am trying to do so:

I need pivot table where in different rows have different expression in same column... like you can do in spreadsheet. I know that variable could treated like expression, but I do not want create lots of variables.

I have tried many different ways to solve problem, one expression in above:




=GetFieldSelections

(sarake1)


And selected value in the field is: sum(myynti)

... really basic expression... but QV is treated field value like string

so how can I change string to expression ?

Any Ideas?

or is this too weird way to solve problem [:P]





4 Replies
prieper
Master II
Master II

Hi,

can you post an example? Might be worth to look at the original data.

Peter

blednyi
Partner - Contributor II
Partner - Contributor II
Author

Here is example what I'm doing..

and find solution when using text-object, how to handle field value to expression:

=
$(=Column1Calc)




But in pivot table I'm not getting solutions[:'(]



johnw
Champion III
Champion III

I must not be understanding what you want, as the pivot table is picking up the same expression as the text object in both 8.5 and 9.0.

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

your logic works just fine, except for the fact that multiple values are available for expressions 2 and 3. If you ensure that only a single value is available at all times, all the expressions will work correctly. You can also use function only(), to ensure that you only want the single available value.

Oleg