Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
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)
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)
Try this...
If(Flag='Diff',[Diff80])
Or you can use set analysis with Aggr
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
Try this in the hearding:
Count({<Flag = {'Diff'}>} FieldName)
or if you need a distinct count
Count(DISTINCT {<Flag = {'Diff'}>} FieldName)
thanks
working fine
Awesome
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.