topic List object filter in QlikView

List object filter

Tue, 12 Apr 2016 19:31:22 GMT

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???

Re: List object filter

sunny_talwar — Tue, 12 Apr 2016 19:36:15 GMT

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)

Re: List object filter

trdandamudi — Tue, 12 Apr 2016 19:41:25 GMT

Try this...

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

Or you can use set analysis with Aggr

Re: List object filter

Tue, 12 Apr 2016 19:42:54 GMT

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

Re: List object filter

sunny_talwar — Tue, 12 Apr 2016 19:46:19 GMT

Try this in the hearding:

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

or if you need a distinct count

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

Re: List object filter

Tue, 12 Apr 2016 19:48:43 GMT

thanks

working fine

Re: List object filter

sunny_talwar — Tue, 12 Apr 2016 19:49:18 GMT

Awesome

Re: List object filter

Wed, 13 Apr 2016 11:17:27 GMT

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.