Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kaylaramsey2
Partner - Contributor III
Partner - Contributor III

Only and Sum used together

I'm having trouble getting the Sum for the last five months in a line chart.

 

Here is the expression I'm using that is not giving me exactly what I need.

 =only({1<DateDT = {"$(= '>=' & addmonths(Max(EventDTS), -5))"}, Campus = {"Combined"}>} SSENBR)

 

I need to add in a Sum(SSENBR) somewhere and I don't know how to do that with 'only'

 Any suggestions?

Labels (1)
3 Replies
m_woolf
Master II
Master II

replace Only with Sum?

kaylaramsey2
Partner - Contributor III
Partner - Contributor III
Author

When I do that it starts to pull in more than the last five months, which is why I need 'only' or something similar

 

sunny_talwar

So when you use this

 =Sum({1<DateDT = {"$(= '>=' & addmonths(Max(EventDTS), -5))"}, Campus = {"Combined"}>} SSENBR)

you see data from more than 5 months old... but when you use this

 =only({1<DateDT = {"$(= '>=' & addmonths(Max(EventDTS), -5))"}, Campus = {"Combined"}>} SSENBR)

You see only 5 months of data? Really? Would you be able to share an image with both expressions and may be DateDT as your dimension to show this?