Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to declare state in multibox

Hi All,

I have a straight table with various expressions for current year, previous year and before previous year.(Total days for current year,Total store for current year .....)

paint2.png

total days expression-

current year expression 

=num(count({< year = {"$(=Max(year))"}>}DISTINCT Sold_Date),'#,##0.0')

previous year expression

=num(count({< year = {"$(=Max(year)-1)"}>}DISTINCT Sold_Date),'#,##0.0') as  so on....

Now I want to make some changes in the report ie on  selection from Ist multi box(i have selected 2017 ) I should get value of 2017

when I select  for 2nd multi box like 2017 , the data should be selected for 2017 (can be seen in mage ).

so what changes should i do in expression and how to maintain alternate state for three different multibox?

paint1.png

3 Replies
karthikoffi27se
Creator III
Creator III

Hi Saksham,

You can create a state in the multibox and assign the state to the multibox so the value changes for the respective state.

Capture.JPG

Many Thanks

Karthik

Anonymous
Not applicable
Author

Following  is the expression  to calculate growth%


Num(((sum({<year = {"$(=Max(year-1))"}>} [inv value] / Sales_INR_Unit) -


sum({<year = {"$(=Max(year)- 2)"}>} [inv value] / Sales_INR_Unit)) /


Sum({<year = {"$(=Max(year)- 2)"}>} [inv value] / Sales_INR_Unit) * 100), '#,##0.0')


but now I want when user selects 1st multibox(sales date for before previuos year as 2017) and when user selects 2nd  multibox(sales date for  previuos year as 2016) and when user selects  3rd multibox(sales date for before current  year as 2017) the growth% should be calculated on basis user selection (i have maintained states for the above situation). I want what changes should i make in my growth% expression so that it can work on users selection ?

Anonymous
Not applicable
Author

=Num(sum(if(GetCurrentSelections(<{StateB<Year=$::Year,Month=$::Month>} [inv value] / Sales_INR_Unit) -

sum({StateA<Year=$::Year,Month=$::Month>} [inv value] / Sales_INR_Unit)) /

Sum({StateA<Year=$::Year,Month=$::Month>} [inv value] / Sales_INR_Unit) * 100),'#,##0.0')

Following Expression is giving an error