Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try this
Quantity 2016 => Sum({$<year = p(MB02)}>} [Quantity])
Quantity 2017 => Sum({$<year = p(MB03)}>} [Quantity])
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.
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])
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