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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Expression

Hello everyone,


How I can get the result of a text from an expression in a pivot table? My text is "SUM (A)", which I have saved in a field.


Regards, Daniel

20 Replies
swuehl
MVP
MVP

Yes, you need to specify the sort weight in the concat, similar to what Miguel used, also in my variable:

=concat(FieldValue( 'FIELD2', valueloop(1,vMaxReg)),',',valueloop(1,vMaxReg))

edit: I attached my modifications together with Miguels suggestion.

edit2:

And as you see, Miguels expression is more simple, if you have a field F3. You could use mine without F3 if you change vMaxReg to something like count(FIELD2) (That's where I started from).