Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Partner
Partner

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 Technical Analyst
Datawarehouse & Business Intelligence
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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

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
Highlighted
MVP & Luminary
MVP & Luminary

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

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

Highlighted
Partner
Partner

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

Thank you very much!!!

Riccardo Schillaci
BI Technical Analyst
Datawarehouse & Business Intelligence
Highlighted
Partner
Partner

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

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 Technical Analyst
Datawarehouse & Business Intelligence