How to export to Excel the expression of a selection list ?

[#1]

Hi all,

I'm new to qlikview and currently evaluating the demo version. I've imported my data and everything is working fine.

I had expression to my selection lists, a distinct count of records id, so that I can know how many items I have for all my parameters when I make the selection.

When I try to send to Excel or export a selection list I only have the items names, not the associated expressions that are exported.

for example, I have a selection list for countries, my list is like that :

Australia (230)

Austria (44)

etc.

but when I export it I only have "Australia" and "Austria" in the export, no values.

Thanks in advance for you help

Vincent

[#2 · Accepted solution]

Hi Vincent,

If you turn Show Frequency on.

Properties -> General Tab, you can see the counts for each value.  When you export that to Excel, the counts are exported.

[#3]

Excellent ! Thanks a lot, sorry for the obvious question !