topic Re: Expression Logic for Selection in QlikView

Expression Logic for Selection

sona_sa — Wed, 19 Jun 2019 10:24:29 GMT

Hi Team,

I have a scenario like.

My selection --> VSelection1 --> I have selected Jan 2019 and VSelection2 --> I have selected Feb 2019 Below my Straight Table where Variance1 --> is VSelection1 selection data and Variance2 --> is VSelection2 selection data and Variance --> is Column1- Column2 (Output).

I have Option1 Radio Button for Millions (M) and Full Value(##,###,##) and Option2 Radi Button for Yes or No Selection (Exclude IFRS Group options).

These are the parameter I have used and my expression logic is working properly. Expression is below:

if(GetFieldSelections(roundingOptions)='Millions',

if(GetFieldSelections(ifrsOptions)='No',

sum({<account={'EXPENSE'},NewDate={'$(=vSelection1)'}>}non_ pti)/1000000,

sum({<account={'EXPENSE'},NewDate={'$(=vSelection1)'}>}non_ pti_ cc)/1000000)

Now I want one more condition that is on Text Dimension --> 1M$ / 2M$ / 3M$ --> By default it is not selected, But If I select 1M$, From the straight table (Greatter Than) >1M$ Value should to display in straight table. If I select 2M$, From the straight table >2M$ Value should to display similarly for 3M$

For Threshold Options I have done the script --

Threshold:
Load * Inline [
Text, Value
'1 M $', 1000000
'2 M $', 2000000
'3 M $', 3000000
];

So team can you help me on this. Thanks for help in advance

Regards,

Re: Expression Logic for Selection

sona_sa — Wed, 19 Jun 2019 11:43:05 GMT

Hi,

I tried by :

if(GetFieldSelections(roundingOptions)='Millions',
if(GetFieldSelections(ifrsOptions)='No',

sum({<sub_account={'EXPENSE_TYPE'},NewDate={'$(=vTime1)'},Text,Value={">$(=only(Value))"}>}non_controllable_pti)/1000000,
sum({<sub_account={'EXPENSE_TYPE'},NewDate={'$(=vTime1)'},Text,Value={">$(=only(Value))"}>}non_controllable_pti_ex_cc)/1000000)

Not Working.

Re: Expression Logic for Selection

Zhandos_Shotan — Wed, 19 Jun 2019 12:26:54 GMT

Hi!

Try this method (https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-modifiers-advanced-searches.htm)

sum( {$<Customer = {“=Sum({1<Year = {2007}>} Sales ) > 1000000”}>} Sales )

Returns the sales for current selection, but with a new selection in the 'Customer' field: only customers who during 2007 had a total sales of more than 1000000.

Depending on which dimension you use to agregate/filter non_ pti sums, try something like:

sum({$<YourAggrDim=

{"=sum({<account={'EXPENSE'},NewDate={'$(=vSelection1)'}>}non_ pti)>$(vOption)"}

>} non_ pti)

Kind regards