topic Re: Set analysis in QlikView

Set analysis

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

Hi Experts,

I trying but i am not getting exact output in set analysis,

These are my condition. i wrote in based on if conditions but i need in set analysis.

In my data i have null values.

=COUNT(IF(LEN(PLAYER)>0 AND LEN(SKILLS)>0,SN))

=COUNT(IF(LEN(PLAYER)>0 OR LEN(SKILLS)>0,SN))

for example

LOAD * INLINE [

SN,PLAYER, SKILLS

1, DHONI, KEEPING

2, DHONI, BATTING

3, KOHLI, BATTING

4, KOHLI, FEALDING

5, , BATTING

6, RAHUL,

];

regards,

vinieme12 — Sat, 28 Jan 2017 06:37:54 GMT

Count ({<SN={"=len (player)>0 or len (skill)>0"} >} SN)

maniram23 — Sat, 28 Jan 2017 06:51:10 GMT

Hi Vineeth,

thanks for your replay,

But i am not getting.

please post your Exercise qvw.

regards,

maxgro — Sat, 28 Jan 2017 06:59:38 GMT

Count ({<SN={"=len (trim(PLAYER))>0 or len (trim(SKILLS))>0"} >} SN)

vinieme12 — Sat, 28 Jan 2017 07:02:29 GMT

You have spaces in your sample , either purgechar the space or trim it as Massimo has shown below

Or try it using an excel load which does not have space or enter characters