Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

Set Analysis

Hi,

I'm having data from 1995 to 2007 only. I need to show the 2007 data as current year and Previous Year as 2006.

I created a variable in Load Script as

SET VCurrentYear=Year(Today());

I used this variable in set analysis.I'm not getting the data .I don't know where i went wrong.

Num(Sum({<[Payroll year]={$(=vCurrentYear)-8}>}RESULT_VALUE),'#,###.00')

I checked $(VCurrentYear)-8 in the Text Object it's showing the year as 2007. But in set analysis its not working.

Can anyone please suggest me.

Regards

krishna

1 Solution

Accepted Solutions
sunny_talwar

If this worked for you in a text box object -> $(VCurrentYear) - 8 (Gave you 2007), then this should work:

Sum({<[Payroll year]={"$(=$(VCurrentYear)-8)"}>}RESULT_VALUE)

View solution in original post

13 Replies
sunny_talwar

See if this works:

=Num(Sum({<[Payroll year]={$(vCurrentYear)-8}>}RESULT_VALUE),'#,###.00')


=Num(Sum({<[Payroll year]={$(VCurrentYear)-8}>}RESULT_VALUE),'#,###.00')

gautik92
Specialist III
Specialist III

create a variable vYear with value 1 and create a input box with that variable add the variabel in set analysis and see

Num(Sum({<[Payroll year]={$(=max([Payroll year]))-vYear}>}RESULT_VALUE),'#,###.00')

krishna20
Specialist II
Specialist II
Author

Hi Sunny,

No it's not working. The text object is showing empty.

tresesco
MVP
MVP

Try :

Num(Sum({<[Payroll year]={$(=$(vCurrentYear)-8)}>}RESULT_VALUE),'#,###.00')

sunny_talwar

What about this:

=Num(Sum({<[Payroll year]={"$(VCurrentYear)-8"}>}RESULT_VALUE),'#,###.00')

sasiparupudi1
Master III
Master III

Num(Sum({<[Payroll year]={"$(vCurrentYear)-8"}>}RESULT_VALUE),'#,###.00')

krishna20
Specialist II
Specialist II
Author

Hi,

I Think there is no input box in Qliksense.

krishna20
Specialist II
Specialist II
Author

Hi Tresesco,

No Luck. It's not working.


Hi Sasidhar,

Your Expression result is zero.

sunny_talwar

First thing first -> Is your variable named vCurrentYear or VCurrentYear?