Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted
Creator II
Creator II

youssefbelloumtresesco

any help on this ???

Highlighted

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

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

Highlighted
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

Highlighted
Creator II
Creator II

hi Ruben ,

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

Kindly help me with the right syntax.

Highlighted
Creator II
Creator II

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

Highlighted

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.

Highlighted
Champion
Champion

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

I need to know what is inside the variable

Highlighted
Creator II
Creator II

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

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