Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
chandana_gowdar
Contributor II

how to pass multiple conditions in set analysis

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

10 Replies
chandana_gowdar
Contributor II

Re: how to pass multiple conditions in set analysis

youssefbelloumtresesco

any help on this ???

Re: how to pass multiple conditions in set analysis

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

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

YoussefBelloum
Esteemed Contributor

Re: how to pass multiple conditions in set analysis

take a look at the above chandana.gowdar

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

chandana_gowdar
Contributor II

Re: how to pass multiple conditions in set analysis

hi Ruben ,

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

Kindly help me with the right syntax.

chandana_gowdar
Contributor II

Re: how to pass multiple conditions in set analysis

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

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.

YoussefBelloum
Esteemed Contributor

Re: how to pass multiple conditions in set analysis

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

I need to know what is inside the variable

chandana_gowdar
Contributor II

Re: how to pass multiple conditions in set analysis

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

YoussefBelloum
Esteemed Contributor

Re: how to pass multiple conditions in set analysis

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..