Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
maniram23
Creator II
Creator II

Set analysis

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,

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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

View solution in original post

4 Replies
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
maniram23
Creator II
Creator II
Author

Hi Vineeth,

thanks for your replay,

But i am not getting.

please post your Exercise qvw.

regards,

maxgro
MVP
MVP

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

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.