Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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