topic Re: how to pass multiple conditions in set analysis in QlikView

how to pass multiple conditions in set analysis

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

hi experts ,

i have a variable declared as given below ,

Count({<{$(vFilterStates)}USD_ASP-={"0"}>} Product_Product_Id)

i am getting error in expression

i guess there is some thing wrong with the syntax

can anyone please help me on this urgently .

its is really really urgent .. Thanks in advance

Re: how to pass multiple conditions in set analysis

Anonymous — Thu, 14 Jun 2018 14:04:53 GMT

youssefbelloum‌ tresesco‌

any help on this ???

Re: how to pass multiple conditions in set analysis

rubenmarin — Thu, 14 Jun 2018 14:08:59 GMT

Hi Chandana, I think you need the change the curly bracket after variable with a comma:

Count({<{$(vFilterStates), USD_ASP-={"0"}>} Product_Product_Id)

Re: how to pass multiple conditions in set analysis

YoussefBelloum — Thu, 14 Jun 2018 14:17:55 GMT

take a look at the above chandana.gowdar

if it is not working for you, try to share the content of vFilterStates variable

Re: how to pass multiple conditions in set analysis

Anonymous — Thu, 14 Jun 2018 14:24:23 GMT

hi Ruben ,

tried with your expression given , it still returns error in expression.

Kindly help me with the right syntax.

Re: how to pass multiple conditions in set analysis

Anonymous — Thu, 14 Jun 2018 14:25:36 GMT

youssefbelloum‌ vFilterStates is working fine ,

issue is with this variable's syntax , please look into it and suggest for the change.

it must be a really minor one , but i am not able to figure out.

thanks

Re: how to pass multiple conditions in set analysis

rubenmarin — Thu, 14 Jun 2018 14:27:39 GMT

It also needs to remove the curly bracket before variable:

Count({<$(vFilterStates), USD_ASP-={"0"}>} Product_Product_Id)

If not, sharing the content of vFilterStates as Youssef saids it's a good idea.

Re: how to pass multiple conditions in set analysis

YoussefBelloum — Thu, 14 Jun 2018 14:27:50 GMT

you give us the expression and not the variable content..

I need to know what is inside the variable

Re: how to pass multiple conditions in set analysis

Anonymous — Thu, 14 Jun 2018 15:18:07 GMT

youssefbelloum‌ is it possible to share your skype Id ? so that i can explain in detail.. this is seeming complicated to explain the whole thing in words .

thanks

Re: how to pass multiple conditions in set analysis

YoussefBelloum — Thu, 14 Jun 2018 15:31:38 GMT

Sorry, I don't use skype,.

Feel free to contact me on youssefbelloutn@gmail.com

But I would recommend you continue here also, community members are maybe stuck on the same thing and search for answers so it can be interesting for them later..

Re: how to pass multiple conditions in set analysis

Frank_Hartmann — Fri, 15 Jun 2018 07:31:02 GMT

try like this:

Count({$(vFilterStates)< USD_ASP-={"0"}>} cProduct_Product_Id)

hope this helps