Qlik Community

App Development

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

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ismqui00
Contributor III
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
vamsee
Specialist
Specialist

Hello,

The syntax would be

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

So.

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


Thanks.

michaelsmith
Contributor III
Contributor III

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.