Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Ignore Year selection, within chart or table

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
Highlighted

Re: Ignore Year selection, within chart or table

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

Highlighted

Re: Ignore Year selection, within chart or table

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)

Highlighted
Partner
Partner

Re: Ignore Year selection, within chart or table

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

Highlighted
Creator
Creator

Re: Ignore Year selection, within chart or table

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