Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vasiliy_beshent
Contributor III

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.

1 Solution

Accepted Solutions

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

4 Replies

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

vasiliy_beshent
Contributor III

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.

2017-05-29 13_07_35-Qlik Sense Desktop.png So i want 74%, 41% 115%

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

erik_wetterberg
Valued Contributor III

Re: How to get all measures in 1 table?

Hi,

You probably could do the formatting in your expression.

Erik

Erik Wetterberg
https://extendingqlik.upper88.com/
vasiliy_beshent
Contributor III

Re: How to get all measures in 1 table?

I make this:

2017-05-29 14_03_05-Qlik Sense Desktop.png

and at the end got what i expect

2017-05-29 14_04_16-Qlik Sense Desktop.png