topic Re: Conditional show in list box in QlikView

Conditional show in list box

Anonymous — Sun, 24 Apr 2016 04:26:41 GMT

Hi All,

If I select Q4on Bar chart, I want to show only Q4 employee names in a list box.

Thanks,

Krishna

johngouws — Sun, 24 Apr 2016 04:33:49 GMT

Hi there.

All I can think of is to hide the Excluded.

Anonymous — Sun, 24 Apr 2016 05:00:56 GMT

Hi john,

Pls check in Excel.

Export employee naems in to Excel and check count.

Q4 Emp count=6054

Excel is shoing wrong (6136)

ashfaq_haseeb — Sun, 24 Apr 2016 06:39:38 GMT

Hi,

I have checked your excel export shows same value 6054

Regards

ASHFAQ

Anonymous — Sun, 24 Apr 2016 07:12:46 GMT

Hi A.Mohammed,

Pls share your excel.

I'm getting same error.

Thanks,

Krishna

ashfaq_haseeb — Sun, 24 Apr 2016 07:16:30 GMT

Hi,

What version of Qlik You use.

It could be there can be issue with your version.

Attached is the exported file.

Try with different version as well.

Regards

ASHFAQ

johngouws — Sun, 24 Apr 2016 11:37:45 GMT

Hi A.Mohammed.

I am not 100% sure what you are wanting to achieve.

I think QlikView is correct! The expression "=Avg(Aggr(Count(DISTINCT([Emp. Id])), Month))" returns the below object.