Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

How to Create Flag for Description text Column

I have data like below 

 

ID Description
1yes 100%
2No
3yes 100%
4it was Compliant 
1Y it was 

 

Need to create flag for Column Description where value is yes or y.

 

even what would be set analysis to only count Description where is yes or Y ?

 

Labels (1)
5 Replies
Partner
Partner

Re: How to Create Flag for Description text Column

Hi

 

maybe you could use something like this

If(Upper(Left(Description,1))='Y','Y','N') AS FLAG

Partner
Partner

Re: How to Create Flag for Description text Column

what would be the set analysis ?

 

Partner
Partner

Re: How to Create Flag for Description text Column

Count ({<FLAG={'Y'}>} Description)

Partner
Partner

Re: How to Create Flag for Description text Column

without using flg column then write the set analysis 

Partner
Partner

Re: How to Create Flag for Description text Column

Count({<Description={'y*'}>}Description)