topic Re: Not able to pass newly created variable in column in QlikView

Not able to pass newly created variable in column

saivina2920 — Sat, 16 Nov 2024 04:12:07 GMT

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.

Sue_Macaluso — Tue, 12 Mar 2019 16:01:24 GMT

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

saivina2920 — Tue, 12 Mar 2019 17:36:22 GMT

This is Qlikview

waszcma1 — Tue, 12 Mar 2019 19:24:18 GMT

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

saivina2920 — Wed, 13 Mar 2019 10:39:38 GMT

Fantastic....