Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chriys1337
Contributor

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

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?

3 Replies
ahaahaaha
Honored Contributor

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

Hi,

Try

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

MVP
MVP

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

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

neelamsaroha157
Valued Contributor II

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

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

(Double Quotes)

Community Browser