4 Replies Latest reply: May 29, 2017 7:04 AM by Vasiliy Beshentsev

# How to get all measures in 1 table?

Hello qlikers!

Here i provide part of my app.

I got months in columns and expr in rows, and the measures, which calculates by exp from my data.

My question is how to collect all this measures into 1 table and how to write correct expr for rows for all these measures - so my point is to write in rows measure description.

• ###### Re: How to get all measures in 1 table?

You'll have to use the ValueList function to create synthetic dimensions and one single expression based on valuelist to generate the correct sub-expressions. Perhaps this blog post helps: ValueList() – For those tricky situations

• ###### Re: How to get all measures in 1 table?

Hello, thanks for your answer, it's good solution for me except 1 problem.

I got all my mesures in 1 table as i want. But there are 3 measures of count and 3 other measures of %.

And % shows in shares.

So i want 74%, 41% 115%

So is there any way to show 2 types of measures in 1 table correctly?

• ###### Re: How to get all measures in 1 table?

Hi,

You probably could do the formatting in your expression.

Erik

• ###### Re: How to get all measures in 1 table?

I make this:

and at the end got what i expect