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: 
Oliver_F
Partner - Creator III
Partner - Creator III

How to pass a list as input parameter to a variable

Hey there,

I am really stuck and hope someone is able to come up with the right syntax.

vVar =

     Count(

        {$<

            %Country = {$1}

        >}

    DISTINCT Customers) > 0

If i count the customers for USA:

=vVar('USA') --> Works great

But how do I count USA and Canada?

=vVar('''USA'',''Canada''') does not do it.


I tried a lot of different syntaxes and I am not able to find any thats is working for me.


All the best and thanks for your help!

2 Replies
antoniotiman
Master III
Master III

Is this typo ?

%Country = {$1},

Oliver_F
Partner - Creator III
Partner - Creator III
Author

I reduced the Code for my Post and forgot to remove the coma. I corrected the original Post, but this is not the problem.

Still not able to pass a list as parameter.