Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

youssefbelloumtresesco

any help on this ???

rubenmarin

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

take a look at the above chandana.gowdar

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

Anonymous
Not applicable
Author

hi Ruben ,

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

Kindly help me with the right syntax.

Anonymous
Not applicable
Author

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

rubenmarin

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

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

I need to know what is inside the variable

Anonymous
Not applicable
Author

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

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