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: 
marcus_steggall
Creator
Creator

Ignore Year selection, within chart or table

Afternoon all,

As per the attached, you'll see I've created two tables.

One showing the total and the other showing what's older than 60 days.

Rightly so, difference being the two months at the bottom, have been taken away and I get the correct answer.

However, when you select any year... the older than 60 days table changes too.

As you can see below, I've put in the Year field (highlighted in red)... which I thought would ignore any user selection, of that field.

sum({<[Year_YYYY]=>} Unbilled_WIP_Amount)
-
Sum({<[Year_YYYY]=,[Period_Sort]={">=$(=max({$}[Period_Sort])-1)<=$(=max({$}[Period_Sort]))"}>} Unbilled_WIP_Amount)

The issue seems to be coming from the second part of the calculation.

Any ideas, where I'm going wrong?

Help much appreciated, as always.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Sum({<[Year_YYYY]=>} Unbilled_WIP_Amount)
-
Sum({<[Year_YYYY]=, [Period_Sort]={">=$(=max({<[Year_YYYY]=>}[Period_Sort])-1)<=$(=max({<[Year_YYYY]=>}[Period_Sort]))"}>} Unbilled_WIP_Amount
)

View solution in original post

4 Replies
sunny_talwar

Try this:

Sum({<[Year_YYYY]=>} Unbilled_WIP_Amount)
-
Sum({<[Year_YYYY]=, [Period_Sort]={">=$(=max({<[Year_YYYY]=>}[Period_Sort])-1)<=$(=max({<[Year_YYYY]=>}[Period_Sort]))"}>} Unbilled_WIP_Amount
)

alexandros17
Partner - Champion III
Partner - Champion III

This is the right expression not dependent on Year:

sum({<[Year_YYYY]=>} Unbilled_WIP_Amount)
  -
 
Sum({<[Year_YYYY]=,[Period_Sort]={">=$(=max({$ <[Year_YYYY]=>}[Period_Sort])-1)<=$(=max({$ <[Year_YYYY]=>}[Period_Sort]))"}>} Unbilled_WIP_Amount)

Mark_Little
Luminary
Luminary

Hi,

Beat me to the post again. But yer like Sunny suggests. You have set analysis within set analysis so you need to exclude the year selection from each.

Mark

marcus_steggall
Creator
Creator
Author

thanks for replying everyone, most helpful as always

Set analysis, within a set analysis... genius this tool and makes sense

Nice one, have a good day all