Qlik Sense App Development

Highlighted Partner

Measuring Two dimensions with same values

Hi my friends

I have a table witch include two dimensions with same values (Not specifically on the same rows ).

I need to count rows for every distinct value on this dimensions, Like the example below.

Any ideas?

Thanks, Sela 5 Replies
Contributor II

Re: Measuring Two dimensions with same values

Hi,

You can try below code.

source A as source,
"A" as flag
from table

concatenate
source B as source,
"B" as flag
from table

and in expression you can try Partner

Re: Measuring Two dimensions with same values

Is there any solution with on-the-fly calculation?

I already tried 'Value list'  and Set Analysis, But it didn't worked.... MVP

Re: Measuring Two dimensions with same values

May be an expression like this

```If(ValueList('Web', 'Phone', 'Email') = 'Web',
Count(DISTINCT {<[Source A] = {'Web'}>} Lead_ID),
If(ValueList('Web', 'Phone', 'Email') = 'Phone',
Count(DISTINCT {<[Source A] = {'Phone'}>} Lead_ID),
If(ValueList('Web', 'Phone', 'Email') = 'Email',
Count(DISTINCT {<[Source A] = {'Email'}>} Lead_ID))))```

and

```If(ValueList('Web', 'Phone', 'Email') = 'Web',
Count(DISTINCT {<[Source B] = {'Web'}>} Lead_ID),
If(ValueList('Web', 'Phone', 'Email') = 'Phone',
Count(DISTINCT {<[Source B] = {'Phone'}>} Lead_ID),
If(ValueList('Web', 'Phone', 'Email') = 'Email',
Count(DISTINCT {<[Source B] = {'Email'}>} Lead_ID))))```

With this dimension

`=ValueList('Web', 'Phone', 'Email')` Partner

Re: Measuring Two dimensions with same values

Thank you for your ans 🙂

I have a long and dynamic list.

Because of that, I need some way to do it without "Ifs".

Is there any way to make it sort and dynamic? MVP

Re: Measuring Two dimensions with same values

Nope, only way is to transform your data using CrossTable load in the script. Can't think of another easy way to do this