Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
New Contributor

Variable question


I am new to Qlik Sense. Trying to create a few button extensions and have the data filter as per the selection of the button. For example, if I click 2017 in one of the button options and select one of the Business Units, the result should get reflected accordingly in the table. I have a few columns/measures in the table.

What I did was create the buttons options, one for Year, one for Business Unit. Then I created variable for Year and Business Unit. Then related the year variable with one of the measures, "Volume" in the Expression Editor. So when I clicked either 2016, 2017 or 2018 the volume would reflect accordingly. That's fine and working.

But I would like the Volume to reflect properly when I click the Business Unit. For that I added the exact same code as "Year" one, just changed it to Business Unit and changed it's variable name too.

Sum({<FY = {$(#vYear)}>}Volume)

Sum({<BusinessUnit = {$(#vBU)}>}Volume)

What am I missing here. Just the first line alone works. Along with the second, I don't get anything!! Please help.

Thank you!!

Tags (1)
2 Replies
Honored Contributor III

Re: Variable question

Sum({<BusinessUnit = {"$(vBU)"}>}Volume)


Sum({<BusinessUnit = {"$(=vBU)"}>}Volume)

New Contributor

Re: Variable question

Thank you! But my question is I want two different variables to work...

Business unit is one field, a button that some options.

Year is another field with some options and is also a button

Volume which is a measure should populate based on the Business unit and Year selected. Currently only one field works.

I have this in my Expression editor.

/*Sum({<FY = {$(#vYear)}>}Volume)*/

Sum({<FY = {"$(vYear)"}>}Volume)

/*Sum({<BusinessUnit = {"$(vBU)"}>}Volume)*/

So currently, if I select one of the options of Year, volume is reflected accordingly. My question is how do I make Business unit to work in the same expression editor for Volume. Is the syntax wrong or is it even doable.

Thanks again for helping!