Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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

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

 

Load

column1, 

column2,

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

From source;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Partner
Partner

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

 

Any thoughts?