Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
marjan_it
Contributor III

list box selected field send to excel dont show in white and gray color

Hi all

in qlikview in normal when we selected some item and a listbox  divided 2 part. some data are selected and show in with color and some data is unselected and show gray. I want when do send to excel  this 2 part be specified.

in some documents show this but in some does not show. what is the setting?

I attach 2 sample of normal type and incorrect type. I want to show all document end to excel show like normal Excel type.

5 Replies
balabhaskarqlik
Honored Contributor

Re: list box selected field send to excel dont show in with and gray color

Create List box field as expression as:

Aggr(Field,Field) - Displays all values of the field, if selected any value, only that value displayed in list box & exported to excel sheet.

Or, if you want to export the Un selected part(gray) colored data, then you need to wright macros, think so.

Re: list box selected field send to excel dont show in with and gray color

You can not get specified using selection filter where Work around always Aggr is the solution in new field measure.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
marjan_it
Contributor III

Re: list box selected field send to excel dont show in with and gray color

thank you. its work but when we create listbox with aggr unselected data does not show in listbox too. then user can not select step by step. Is there any solution?

marjan_it
Contributor III

Re: list box selected field send to excel dont show in white and gray color

There is no one to help me?

marjan_it
Contributor III

Re: list box selected field send to excel dont show in white and gray color

I found the reason that dont show in different color. when the list box have many fields in send to excel does not show selected Item and unselected item.

now what should i do?