Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Bobbet
Contributor III
Contributor III

Set analysis using variable Year does not provide values

Hi,

  I have the following statement and it seems the values are not displaying.  I suspect that the vLastYear variable is the issue. Hope to get inputs. Thanks!

count({$<transaction_type-= {'Union_Bank'}, Year={$(vLastYear)}>} distinct transaction_id)

 

Bobbet

10 Replies
shivanisapkale
Partner - Creator
Partner - Creator

Hi,

Call the variables also in a kpi and see what is the result and check the output is same as desired output.

Regards,

Shivani Sapkale