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: 
lghadage
Contributor
Contributor

Regarding Selecting fields from list box and exporting selected fields in to excel sheet in qliksens

I have created list box with check box, one can select one or many check boxes at a time and these selected fields are added to a table box and now i want to export the fields in custom table, I tried to achieve it by Pick and mach expression but then i came to know pick and Match cant be used with list boxes, i tried using if statement as well but no luck,

When i select one field then column it works perfectly fine but when i select multiple fields columns are not getting added properly, can anyone please suggest what can be done in this case.

expression i am using is as below,

=pick(match(GetFieldSelections(Dimensions_External)='GLBL_COUNTRY',
GetFieldSelections(Dimensions_External)='GLBL_SIC',
GetFieldSelections(Dimensions_External)='Global_Duns',
GetFieldSelections(Dimensions_External)='MAJOR_DIVISION', GLBL_COUNTRY,GLBL_SIC,Global_Duns,MAJOR_DIVISION))

 

If statement i am using is as below,

 

=if(GetFieldSelections(Dimensions_External)='GLBL_COUNTRY',GLBL_COUNTRY)
,if(GetFieldSelections(Dimensions_External)='GLBL_SIC',GLBL_SIC)
,if(GetFieldSelections(Dimensions_External)='Global_Duns',Global_Duns)
,if(GetFieldSelections(Dimensions_External)='MAJOR_DIVISION',MAJOR_DIVISION)

2 Solutions

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Hi,

This won't work as you stated. You can also test this by putting your statement in a text box. You will see that it will return a '-'. This is because a pick(match()) will only pick one value. 

What do you mean with exporting the fields in a custom table? You want the users to select their own dimensions? Because if you want this, you can better use the Climber Custom Report which makes it way easier, check the link.

Jordy
Climber

Work smarter, not harder

View solution in original post

lghadage
Contributor
Contributor
Author

Thanks Jordy,this is what i was looking for.

View solution in original post

2 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

This won't work as you stated. You can also test this by putting your statement in a text box. You will see that it will return a '-'. This is because a pick(match()) will only pick one value. 

What do you mean with exporting the fields in a custom table? You want the users to select their own dimensions? Because if you want this, you can better use the Climber Custom Report which makes it way easier, check the link.

Jordy
Climber

Work smarter, not harder
lghadage
Contributor
Contributor
Author

Thanks Jordy,this is what i was looking for.