topic Re: Set Analysis select a date, up to this date the information should be shown in QlikView

Set Analysis select a date, up to this date the information should be shown

chriys1337 — Tue, 11 Apr 2017 15:17:38 GMT

Hi all,

I am having a table with sales figures including a calendar week field ([Closed: kick-OUT volumes], e.g. 201717).

I would like to select just ONE week in this field and my chart should show all figures up to this week.

I realized that it should be possible with Set Analysis, but somehow it does not work for me:

sum({<Validity={'MT'}, [Closed: kick-OUT volumes]={'<=$(=max([Closed: kick-OUT volumes]))'}>}Sales)

Is anything wrong with my expression?

ahaahaaha — Tue, 11 Apr 2017 15:20:44 GMT

Hi,

Try

sum({<Validity={'MT'}, [Closed: kick-OUT volumes]={"<=$(=max([Closed: kick-OUT volumes]))"}>}Sales) marked in red

sunny_talwar — Tue, 11 Apr 2017 15:21:37 GMT

It looks right to me... have you checked what =max([Closed: kick-OUT volumes]) gives you in a text box object?

neelamsaroha157 — Tue, 11 Apr 2017 15:22:07 GMT

Sum({$<Validity={'MT'}, [Closed: kick-OUT volumes]={"<=$(=Max( [Closed: kick-OUT volumes]))"}>}Sales)

(Double Quotes)