Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
praveenkumar_s
Contributor II

create variable using dimensions

Hi,

I have  dimension category, spendUSD and variable vOppurtunityMax1 ..

Sum({<CATEGORY= {'<=$(vOppurtunityMax1)'}>}spendUSD)

and vOppurtunityMax1 has top category like HR.. i want sum of spend for the category HR via variable..how can i achieve this in qlik sense??