topic Compare two columns in QlikView

Compare two columns

Thu, 14 Aug 2014 12:15:14 GMT

Hi guys,

I am struggling with below simple case. I have got data like this:

LOAD * INLINE [

ID, AMT

1, 100

2, 200

3, 400

];

LOAD * INLINE [

TST

];

And when I select two values or more on TST then I would like to see this values be selected on ID and show me sum of AMT for it.

Please check below images and my incorrect expression.

Correct:

My Problem:

Thank You in advance!

Sebastian

Re: Compare two columns

giakoum — Thu, 14 Aug 2014 12:19:18 GMT

if you write ID={'1,3'} it will work.

To have that live and not hard coded, use the concat function to create the 1,3 or whatever is selected, and use it either directly or through a variable in your set analysis

Somehting like : ID={"$(=concat(TST, ','))"}

Re: Compare two columns

Anonymous — Thu, 14 Aug 2014 12:20:26 GMT

you have to use the concat function

sum({<ID={=concat(TST,",")}>}AMT)

Re: Compare two columns

maxgro — Thu, 14 Aug 2014 12:23:15 GMT

maybe

sum({$ <ID=P(TST)>} AMT)