topic Re: comparing two string variables in QlikView

comparing two string variables

Fri, 19 Jun 2015 01:14:53 GMT

Hi experts,

can you please let me know how to compare string variables in qlikview UI. For example I have two variables A and B

with below values

I want to get distinct count after combining these values which is 5. Please help.

Thanks,

jagan — Fri, 19 Jun 2015 02:30:54 GMT

Hi,

Change your script like below

Data:

LOAD

A & '|' & B AS Key

INLINE [

A, B

A1234, A1234

A5678, A5675

A8901, A5432];

SplitValues:

LOAD

Key,

SubField(Key, '|') AS CountField

RESIDENT Data;

Now use below expression to get distinct Count

=Count(DISTINCT CountField)

Hope it helps you.

Regards,

Jagan.

Fri, 19 Jun 2015 02:34:31 GMT

Hi Jagan Mohan,

Thanks for response I don't want logic in script, it needs to be in UI variables is based on complex condition and derived in UI. Please help. Thanks

jagan — Fri, 19 Jun 2015 02:49:38 GMT

Hi,

My suggestion is to do this in script, it is the best practice. If it is complicated then use below expression

=Count(DISTINCT A) + Count(DISTINCT B) - Count({<A=P(B)>} DISTINCT A)

Regards,

Jagan.