topic Re: Get listbox value in table in QlikView

Get listbox value in table

reyouk3310 — Tue, 09 Oct 2018 09:39:50 GMT

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 — Tue, 09 Oct 2018 15:46:16 GMT

Try this

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

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

reyouk3310 — Tue, 09 Oct 2018 16:02:05 GMT

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 — Tue, 09 Oct 2018 16:17:42 GMT

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 — Tue, 09 Oct 2018 16:27:00 GMT

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