topic Re: Conditional show in list box in QlikView

Re: Conditional show in list box

Anonymous — Sun, 24 Apr 2016 07:33:45 GMT

Hi,

Please export list box(Employee names) and check count .

=Aggr([Employee Name],[Employee Name]) use this expression for list box. next check Hide Excluded.

Next click on Q4 or Q3 or Q2 or Q1. next export Employee names(List Box) to Excel. next check count.

Q4 count is 6054

Q4 Excel count is 6136.(Employee Names)

Thanks,

Krishna

MK_QSL — Sun, 24 Apr 2016 08:27:52 GMT

If you want to match Employee Name count then you have to use below expression

=COUNT(DISTINCT [Employee Name])

Anonymous — Sun, 24 Apr 2016 08:46:55 GMT

Hi Manish,

=COUNT(DISTINCT [Employee Name]) this Expression returns 0 values.

Thank

Krishna

agni_gold — Sun, 24 Apr 2016 09:35:56 GMT

You are making Average count in chart , but in list box it will not show avg values.

If you want count match then you need to use text box , see in attached file.

MK_QSL — Sun, 24 Apr 2016 17:24:54 GMT

This expression you have to use in Bar Chart... Not in List Box