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

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

View solution in original post

4 Replies
Highlighted
Community Manager
Community Manager

Hi, is this for QlikView or Sense? I would like to move this post into the product forums
Sue Macaluso
Highlighted
Creator
Creator

This is Qlikview
Highlighted
Creator
Creator

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

View solution in original post

Highlighted
Creator
Creator

Fantastic....