topic Re: Need help to write an expression in the combination of alternate state and set analysis in QlikView

Need help to write an expression in the combination of alternate state and set analysis

bvssudhakar — Sat, 16 Nov 2024 21:47:13 GMT

Hello Experts,

I need a help to write the Expression. I have a Expression something like this

=if(USD_ASP<>0 and ProductType = 'Recommended',Count({Selection1*Selection3}Product_Product_Id)),Count({Selection2*Selection3}Product_Product_Id)))

But this is accepting USD_ASP's Zero values. Can you guys please check this query and help me out from this.

Selection1, Selection2, Selection3 are alternate states

Re: Need help to write an expression in the combination of alternate state and set analysis

bvssudhakar — Mon, 03 Dec 2018 14:57:38 GMT

@sunny_talwar @Frank_Hartmann

Can you guys Please have a look and help me out from this

Thank you in advance

Re: Need help to write an expression in the combination of alternate state and set analysis

hopkinsc — Mon, 03 Dec 2018 14:59:17 GMT

Hi, what is accepting zero values exactly, the else in the IF would accept zero values.

What exactly do you want the IF statement to do?

Re: Need help to write an expression in the combination of alternate state and set analysis

bvssudhakar — Mon, 03 Dec 2018 15:03:49 GMT

Hi,

I want to show the count (Product_product_Id) where USD_ASP <>0 by using alternate states

can you please modify that expression.

Re: Need help to write an expression in the combination of alternate state and set analysis

hopkinsc — Mon, 03 Dec 2018 15:13:39 GMT

What about..

=if(ProductType = 'Recommended',
Count({Selection1*Selection3<USD_ASP={'>0'}>}Product_Product_Id),
Count({Selection2*Selection3<USD_ASP={'>0'}>}Product_Product_Id))

are there any USD_ASP <0?

Re: Need help to write an expression in the combination of alternate state and set analysis

bvssudhakar — Mon, 03 Dec 2018 15:56:55 GMT

Hi @hopkinsc

It is some thing working, But my total expression is this. if write this expression it is showing error in expression

Can you please check for this once

=if(ProductType = 'Recommended',Sum({{Selection1*Selection3<USD_ASP={">0"}>}USD_ASP),Sum({Selection2*Selection3<USD_ASP={">0"}>}USD_ASP))/
if(ProductType = 'Recommended',Count({Selection1*Selection3<USD_ASP={">0"}>}Product_Product_Id),Count({Selection2*Selection3<USD_ASP={">0"}>}Product_Product_Id))*ExchangeRate

Thank you in advance

Re: Need help to write an expression in the combination of alternate state and set analysis

hopkinsc — Mon, 03 Dec 2018 16:23:48 GMT

you have 2 brackets in the first sum..

remove 1 and see if that helps

Re: Need help to write an expression in the combination of alternate state and set analysis

bvssudhakar — Mon, 03 Dec 2018 16:35:49 GMT

Hi @hopkinsc

Thank you very much for the solution. It's working Now