topic Re: How to declare state in multibox in QlikView

How to declare state in multibox

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 .....)

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?

Re: How to declare state in multibox

karthikoffi27se — Mon, 05 Mar 2018 10:28:16 GMT

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.

Many Thanks

Karthik

Re: How to declare state in multibox

Anonymous — Mon, 05 Mar 2018 11:18:20 GMT

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 ?

Re: How to declare state in multibox

Anonymous — Mon, 05 Mar 2018 12:33:48 GMT

=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