Independent calculated dimension

Fri, 11 Jul 2014 06:41:13 GMT

Hi,

I have 6 fields:

Name_1

Name_2

Phone_1

Phone_2

Mail_1

Mail_2

I have a chart and would like to create a calculated dimension as follow where the values are:

Names are different ( when Name_1 <> Name_2)

Phones are different ( when Phone_1 <> Phone_2)

Mails are different ( when Mail_1 <> Mail_2)

If I do it with if and else as follow :

IF ( Name_1 <> Name_2 ,

'Names are different',

IF( Phone_1 <> Phone_2,

'Phones are different',

IF( Mail_1 <> Mail_2,

'Mails are different',

'-'

)

I will have in the line of the 'Phones are different' only the records where the name is equal and phone different - since this condition comes in the else.

And that's not what I want. I want the conditions to be independent one from other.

Do you have an idea?

Thanks,

Yael

Re: Independent calculated dimension

Gysbert_Wassenaar — Fri, 11 Jul 2014 11:06:53 GMT

You can't do this in one dimension. Perhaps you can create flag fields in the script. In a chart you can then use expressions to count the records independently.

topic Independent calculated dimension in QlikView

Independent calculated dimension

Re: Independent calculated dimension