topic Re: Using different expression based upon a box selection in QlikView

Using different expression based upon a box selection

helen_pip — Fri, 21 Apr 2017 15:33:04 GMT

Dear Qlikview user

I am not sure how to go about this, but I want to create an expression for when a user has a selection on FiscalYear, the text box will display one expression, but as soon as Month is selected also, a different expression displays

I do not know whether I would need 2 text boxes on a show/hide scenario, or whether Qlikview has an already built in function which allows you to change expressions based on the users selections

I.e.

If(Fiscal Year is selected then,

Num(sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevYear)>} If(RTT_WEEKS_WAIT <'18', RTT_COUNTER))/

sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevYear)>}RTT_COUNTER), '0.00%'),

If(Fiscal Year and Month is selected Then,

Num(sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevMonth)>} If(RTT_WEEKS_WAIT <'18', RTT_COUNTER))/

sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevMonth)>}RTT_COUNTER), '0.00%'),

Am I looking to use something like:

GetCurrentField

GetCurrentSelections

Any help would be greatly appreciated

Kind Regards

Helen

Re: Using different expression based upon a box selection

Nicole-Smith — Fri, 21 Apr 2017 15:42:38 GMT

If(GetSelectedCount(FiscalYear) > 0,

Num(sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevYear)>} If(RTT_WEEKS_WAIT <'18', RTT_COUNTER))/

sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevYear)>}RTT_COUNTER), '0.00%'),

If(GetSelectedCount(FiscalYear) > 0 and GetSelectedCount(Month) > 0,

Num(sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevMonth)>} If(RTT_WEEKS_WAIT <'18', RTT_COUNTER))/

sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevMonth)>}RTT_COUNTER), '0.00%'),

If you want to only do it if they have ONE year or month selected, change the "> 0" to "= 1".

Re: Using different expression based upon a box selection

helen_pip — Sun, 23 Apr 2017 19:18:36 GMT

Hello Nicola

Thank you for your help, this works for me

Kind Regards

Helen