Get listbox value in table

[reyouk3310]

Hi all,

I'm using Qlikview and I want to compare the product quantity of each country in the same table by year.

I have create two alternatives statas in order to create two independent listboxes by using same dimension year.

Actually, I want to put in the set analysis of each column a condition which allows me to get the value of each listebox

I have tried GetCurrentSelections to get the object value, but it does not work.

Quantity 2016  => Sum({$<year={$(=GetCurrentSelections(MB02))}>}   [Quantity])

Quantity 2017  => Sum({$<year={$(=GetCurrentSelections(MB03))}>}   [Quantity])

Do you have an idea please ?

Thanks

[sunny_talwar]

Try this

Quantity 2016  => Sum({$<year = p(MB02)}>}  [Quantity])

Quantity 2017  => Sum({$<year = p(MB03)}>}  [Quantity])

[reyouk3310]

Hi Sunny Talwar,

Thank you for the message. I tried it but it does not work.

For your information, MB02 and MB03 are the Object ID of the two lisbox.

[sunny_talwar]

Oh okay, I guess you have Year field in two different states? Try this

Quantity 2016  => Sum({$<year = [GroupA]::year>}  [Quantity])

Quantity 2017  => Sum({$<year = [GroupB]::year>}  [Quantity])

[reyouk3310 · Accepted solution]

Thank you again.

Your seconde proposition give me the total of all states.

I have tried the following set analysis ant it works now:

Quantity 2016  => Sum({[GroupA]*$}  [Quantity])

Quantity 2017  => Sum({[GroupB]*$}  [Quantity])

Thank you veru much