Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

Not able to pass newly created variable in column

I am unable to get the exact result when i'm passing the new variable to my column in Expression.

For Example, i have created one variable called vOrigin.

i have map one seleted fields with this vOrigin. 

So , 

vOrigin - GetFieldSelection(EmpNo).

When i'm using the above variable in my Expression, i could not find any difference. it will always shows zero value.

 

Below is my Expression:
=Count({<[From]= vOrigin , [To]={'USA-CANADA'}>} DISTINCT [Country ID])

pls. let me know where is the problem in my count.

Labels (1)
1 Solution

Accepted Solutions
waszcma1
Partner - Creator II
Partner - Creator II

try this:
=Count({<[From]= {"$(vOrigin)"} , [To]={'USA-CANADA'}>} DISTINCT [Country ID])

View solution in original post

4 Replies
Sue_Macaluso
Community Manager
Community Manager

Hi, is this for QlikView or Sense? I would like to move this post into the product forums
Did you find a solution to your question? Mark the solution as accepted : and if you found it useful, press the like button!
saivina2920
Creator
Creator
Author

This is Qlikview
waszcma1
Partner - Creator II
Partner - Creator II

try this:
=Count({<[From]= {"$(vOrigin)"} , [To]={'USA-CANADA'}>} DISTINCT [Country ID])
saivina2920
Creator
Creator
Author

Fantastic....