Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Expression Help

Hi Team,

I have list box: Name is Text and Option is 1M$, 2M$ and 3M$.

Now If User Select 1M$ then I need amount, which is greater than >1M$ from my records. Else By default, If Not selection is there – then 0, If user select 2M$ then greater than >2M$ from my records and when user select 3M$ then greater than >3M$ from my records and By default 0.

Below is my expression where I want to add this condition.

if(GetFieldSelections(Options1)='Millions',

if(GetFieldSelections(Options2)='No',

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

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

Can anyone make an expression for the same.

AK

Labels (1)
2 Replies
Highlighted
Creator
Creator

Hi Team,

I have a scenario like. In Brief of previous one.

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,

AK

Highlighted
Creator
Creator

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.

AK