Expression Logic

sona_sa — Thu, 20 Jun 2019 16:57:01 GMT

Hi Team,

I am using 3 List box for the same.

Option1:
Load * Inline [
Option1
Million (Means will display the value in M)
Full Value (Means Full Value in Integer. like --> 20000000000.25614)
];

Option2:
Load * Inline [
Option2
'1 M $'
'2 M $'
'3 M $'
];

Option3:
Load * Inline [
Option3
Yes
No
];

If I select Option1 = 'Million ' and Option2 = '1M$' and Option3 = 'No'Then I want the sum of Non_PTI, Where Value will be in Million which is Greater Then 1M

If I select Option1 = 'Million ' and Option2 = '2M$' and Option3 = 'No'Then I want the sum of Non_PTI, Where Value will be in Million which is Greater Then 2M

If I select Option1 = 'Million ' and Option2 = '3M$' and Option3 = 'No' Then I want the sum of Non_PTI, Where Value will be in Million which is Greater Then 3M

For --> sum({<account={'EXPENSE'}>}non_ pti)

Else sum({<account={'EXPENSE'}>}non_ pti_cc) --> This would be also in Million and Greater Than 1M or 2M or 3M As is it previous If selection. Only here Sum value is different -non_ pti_cc

Can You make an expression with these 3 condition for me.

Please do the needful.

Re: Expression Logic

Brett_Bleess — Mon, 22 Jul 2019 15:44:25 GMT

Per your prior post, this seemed to be an issue in your data model, not the actual expressions, there were no links between your tables in the data model, which is what I expect the issue is in this case as far as things not working. It is best not to create duplicate posts as well, please use the original post and add additional information if nobody is answering, as this is generally why you are not receiving answers, there is not enough information provided for someone to be able to help.

Regards,
Brett

topic Re: Expression Logic in QlikView

Expression Logic

Re: Expression Logic