Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
ismqui00
New Contributor III

Dimension/ Measure Expression

Need to create a new expression to use in table. The expression should incorporate our 'completed_at' date field i'm pretty sure, but I want it to pull dates only within, lets say, a two month period.

The expression I have so far is:

Sum({<completed_at={>=$(=Max(completed_at)-60))

Any help is appreciated.  Thanks in advance.

2 Replies
Highlighted
vamsee
Valued Contributor

Re: Dimension/ Measure Expression

Hello,

The syntax would be

    {<TIME_KEY = {">$(vFirstPeriod) <$(=vLastPeriod)"} >}

So.

Sum({<completed_at={">=$(=Max(completed_at)-60)<$(=completed_at))"}>}ABCD)


Thanks.

Highlighted
michaelsmith
New Contributor III

Re: Dimension/ Measure Expression

When you use >= within set analysis you need to use quotation marks - single or double depending upon the contents. For your purposes you should get away with something like the following:

Sum({<

          completed_at={'>=$(=(Max(completed_at)-16))'}

          >}

          ValueToSum)

Hope this helps.