Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Front End Table

Hi All , I have 1 table

IDFlag
1Yes
2 
3Yes
4 
5 
6Yes

 

In Front end Table i Need 

Dimension as ID with Flag is yes Expression 1 : count of Total ID'sExpression 2 : count of ID's with Flag Yes
161
361
661

 

How can i get this ?

Please note in Dimension i want to See only ID's with Flag Yes ( 1,3,6 )

Advance Thanks

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

May be this

Expression 1

If(Flag = 'Yes', Count(TOTAL ID))

 

Expression 2

Count({<Flag = {'Yes'}>}ID)

 

View solution in original post

1 Reply
sunny_talwar

May be this

Expression 1

If(Flag = 'Yes', Count(TOTAL ID))

 

Expression 2

Count({<Flag = {'Yes'}>}ID)

 

View solution in original post