topic Re: using calulated dimension in total functions in QlikView

using calulated dimension in total functions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi ,

So my data looks something like this

F1 F2

A X

A Y

B X

B Y

I want to see occurrences when more than 1 F2 exists for a F1 i used a total function to get this ,

but problem is when i try making the dimensions dynamic by choosing F1 and F2 among F1,F2,F3,F4,F5 and F6 based on button selections, i can't seem to use the calculated expression in the total function

the expression I'm using is if(count(distinct total<F1> F2)>1,red())

i don't seem to understand why it doesn't work for calculated dimensions

Re: using calulated dimension in total functions

sunny_talwar — Wed, 21 Mar 2018 15:27:48 GMT

This is a color expression?

if(count(distinct total<F1> F2)>1,red())

What are you using as calculated dimension?

Re: using calulated dimension in total functions

ychaitanya — Wed, 21 Mar 2018 15:39:34 GMT

Hi Sudip

You could use the AGGR() function instead and check the counts. Something like this.

if(Aggr(Count(distinct F2),F1)>1,Red())