Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On-Demand Webinar: Learn proven best practices for a smooth transition to Qlik Sense® SaaS. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kaylaramsey2
Partner - Contributor III
Partner - Contributor III

Combining two dimensions into one

Hello,

 

I am trying to combine two dimensions into one.  I need every result of the first column but only one specific result of the second column.

I tried this:

=pick(match($Field, 'column1', 'column2'), column1, only({<column2 = {'12345'}>} column2))

However this keeps giving me an error.  Is there another way to combine these two columns?

Labels (2)
2 Replies
Vegar
MVP
MVP

Have you considered solving this by creating the logic in your script?

 

Load

column1, 

column2,

If(column2=12345,12345,Column2) as Column12

From source;

kaylaramsey2
Partner - Contributor III
Partner - Contributor III
Author

This would probably work.  I'd prefer it to go directly into the expression if it is possible.

 

Any thoughts?