Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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..