topic Combining two dimensions into one in QlikView

Combining two dimensions into one

kaylaramsey2 — Sat, 16 Nov 2024 03:11:52 GMT

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?

Vegar — Mon, 24 Jun 2019 22:24:44 GMT

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 — Tue, 25 Jun 2019 17:13:51 GMT

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

Any thoughts?