Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Conditional show in list box

Hi All,

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

Thanks,

Krishna

6 Replies
johngouws
Partner - Specialist
Partner - Specialist

Hi there.

All I can think of is to hide the Excluded.

Sample.PNG

Anonymous
Not applicable
Author

Hi john,

Pls check in Excel.

Export employee naems in to Excel and check count.

Q4 Emp count=6054

Excel is shoing wrong (6136)3.PNG

ashfaq_haseeb
Champion III
Champion III

Hi,

I have checked your excel export shows same value 6054

Regards

ASHFAQ

Anonymous
Not applicable
Author

Hi A.Mohammed,

Pls share your excel.

I'm getting same error.

Thanks,

Krishna

ashfaq_haseeb
Champion III
Champion III

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
Partner - Specialist
Partner - Specialist

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.

Capture.PNG