Skip to main content

New to Qlik Sense

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

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kumarkush
Contributor
Contributor

Comparing variable to Month in expression

Hi Guys,

I'm trying to use set analysis to calculate M2D & Y2D values for some measure which should remain constant irrespective of other selections.

I'm storing the current Month, Year in separate variables defined as vYear = Year(Today()).

I have a separate field from my database which is called 'Year'.

Now, my set analysis expression looks like :

Sum({1<[Year]={'$(vYear)'}>}OOS)

However, this returns no results whereas if I output the values through KPI indicators, they both say '2018'.

If I change my variable from the function to just '2018', this works fine.

My first thought is that there is a datatype mismatch - which I have no idea how to handle in QS.

Would you be able to point what the issue is?

2 Replies
juraj_misina
Luminary Alumni
Luminary Alumni

Hi,

is your vYear variable defined with leading equal sign?

Juraj

agigliotti
Partner - Master III
Partner - Master III

let's try as below:

Sum( {1< Year = {"$(=(vYear))"} >} OOS )

hope it helps.