Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (2)
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
Sue Macaluso
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....