Default selection in expression

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

Hi,

Can some one help me here

i wrote simple condition as below.in that i want to include WW as default value how can i do that. and again if i select some thing from my filters it should take that value.

example from filters if i select Geogarphy ='APJ' it should give me APJ Values in my report.

Filed name is Global and value is also WW.

num ( SUM ({<ScenarioLabel={'Actuals'}>} NumValue) / SUM ({<ScenarioLabel={'Actuals'}>} DenValue), '0.#%'),

Num( SUM ({<ScenarioLabel={'Actuals'}>} NumValue),'##,###.0'),

Best Regards,

Re: Default selection in expression

swuehl — Sat, 06 Oct 2018 08:17:23 GMT

Maybe like

If( Len(GetCurrentSelections()), //check if there are any selections

Num( SUM ({<ScenarioLabel={'Actuals'}>} NumValue),'##,###.0'), // yes --> consider selections

Num( SUM ({<ScenarioLabel={'Actuals'}, Global = {'WW'}>} NumValue),'##,###.0'), // no --> use default

)

topic Default selection in expression in QlikView

Default selection in expression

Re: Default selection in expression