topic How to use set analysis with if statement? in QlikView

How to use set analysis with if statement?

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

Hi Community,

How can I best approach the following issue. I have two fields, which likely have the same values (type1 and type2) and want to count based on customer ID.

Example:

Data:

LOAD * inline [

Customer|Type1|Type2

Astrida|TV|Radio

Astrida|TV|Ref

Astrida|TV|TV

] (delimiter is '|');

In word: only count Customer if Type1 and Type2 have the equal field, and ignore all rows which do not comply with the formula.

Thanks in advance.

Re: How to use set analysis with if statement?

sunny_talwar — Wed, 30 May 2018 14:32:36 GMT

Look here

How to create Set Analysis in combination with If statement?

Re: How to use set analysis with if statement?

mrichman — Wed, 30 May 2018 18:10:17 GMT

Hi Sunny, thanks. Some lag occured.