topic Re: How to get all measures in 1 table? in App Development

How to get all measures in 1 table?

Vasiliy_Beshentsev — Fri, 26 May 2017 13:22:14 GMT

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?

Gysbert_Wassenaar — Fri, 26 May 2017 14:27:50 GMT

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?

Vasiliy_Beshentsev — Mon, 29 May 2017 10:14:00 GMT

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?

ErikWetterberg — Mon, 29 May 2017 11:02:16 GMT

Hi,

You probably could do the formatting in your expression.

Erik

Re: How to get all measures in 1 table?

Vasiliy_Beshentsev — Mon, 29 May 2017 11:04:38 GMT

I make this:

and at the end got what i expect