Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
danielrogra
Contributor

Measure by dimension

Hi all

I'm facing the following issue: I have a table with 3 kinds of information

TotalTypeType2
1

A

A.1
2AA.2
1B
3B
1C
6C

and I'm trying to build the following pivot table:

sum (Total) where type=Asum (Total) where type=Bsum (Total) where type=C
A.1

1

47
A.2247

Is there a way to do that?

Thanks in advance

Regards

Tags (2)
1 Solution

Accepted Solutions

Re: Measure by dimension

Hi Daniel, as Type2 is not related to all records you can use TOTAL qualifier to avoid dimension values, and apply set analysis to filter by Type.

Using Type2 as dimension and 3 expressions/metrics:

- Sum({<Type={'A'}>} Total)

- Sum(TOTAL {<Type={'B'}>} Total)

- Sum(TOTAL {<Type={'C'}>} Total)


Naming a field 'Total' can make diffficult to different the qualifier TOTAL and the field Name.

1 Reply

Re: Measure by dimension

Hi Daniel, as Type2 is not related to all records you can use TOTAL qualifier to avoid dimension values, and apply set analysis to filter by Type.

Using Type2 as dimension and 3 expressions/metrics:

- Sum({<Type={'A'}>} Total)

- Sum(TOTAL {<Type={'B'}>} Total)

- Sum(TOTAL {<Type={'C'}>} Total)


Naming a field 'Total' can make diffficult to different the qualifier TOTAL and the field Name.