List object filter

[#1]

Hi

I have a  total field values(140 values) and i created a flag with 'Diff' and 'Same' values. After creating Flag out of 140 rows from that field, 80 are 'Diff' and 60 are 'Same' values.now i want to display only those 'Diff'(80) as list in list box.

How to do in front end  part???

[sunny_talwar · Accepted solution]

May be try this as your list box expression:

Aggr(Only({1<Flag = {'Diff'}>} FieldName), FieldName)

Alternatively, this can also work:

If(Flag = 'Diff', FieldName)

[trdandamudi]

Try this...

If(Flag='Diff',[Diff80])

Or you can use set analysis with Aggr

[#4]

Hi sunny

Thanks for quick response...

this expression is working fine at the same time i want to display count of diff values i.e diff - 80 but its showing total values like 140 as heading

[sunny_talwar]

Try this in the hearding:

Count({<Flag = {'Diff'}>} FieldName)

or if you need a distinct count

Count(DISTINCT {<Flag = {'Diff'}>} FieldName)

[#6]

thanks

working fine

[sunny_talwar]

Awesome

[#8]

Great. Your instant response is much helpful.

Also,We are having one issue from few days , please find below link for details and let me know if any information needed.

Check out 'How to pass comments from multiple sheets to Home page specific to month wise' in Qlik Community.
https://community.qlik.com/thread/212948

We have got struck and If you could provide some valuable inputs,very much helpful.

Thanks in advance.