Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Riccardo
Partner - Creator III
Partner - Creator III

How can I use X measures in one column with X fixed rows?

Hi,

I've uploaded my app example.

I have a table with DATE and 3 Measures.

I would like to show these measures in a column only, with 3 fixed rows, dinamically.

My example works if I print the same measure, but if I'm going to print 2 or 3 different measure, it doesn't work. Why?

Thank you, regards.

Riccardo

Riccardo Schillaci
BI Analyst
Datawarehouse & Business Intelligence
1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can't do it that way. The reason is a bit complicated. Just remember to either not to try this kind of dynamic expressions or use a pick-match combination like in the attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

You can't do it that way. The reason is a bit complicated. Just remember to either not to try this kind of dynamic expressions or use a pick-match combination like in the attached qvw.


talk is cheap, supply exceeds demand
Riccardo
Partner - Creator III
Partner - Creator III
Author

Thank you very much!!!

Riccardo Schillaci
BI Analyst
Datawarehouse & Business Intelligence
Riccardo
Partner - Creator III
Partner - Creator III
Author

Hi,

is there a way to use single quote inside the formula?

Like this:

sum({<Date={'=$(V_Max_Date)'}>} MEASURE)

If I put this inside my LOAD INLINE, the table fails!

Thanks

Riccardo Schillaci
BI Analyst
Datawarehouse & Business Intelligence