Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to Sum, allowing only one field to filter....

So I am very new to Qlikview and while I've found it very useful, I am running into an issue.  I have spend data that is able to be filtered by location, date, cost center, etc...  I have created a text object which sums all of the spend, regardless of the selections; Sum(ALL SPEND_AMOUNT).  I have another text object which sums the filtered spend; SUM(SPEND_AMOUNT).  I am now being asked if there is any way to create a text object that sums all of the spend, but allows the date to be used as a filter, and only the date.  In essense, they want the spend total to be filtered in this object, but only by this one field.  As a side, the dates are broken out by YEARNAME, QUARTERNAME, and MONTHNAME; allowing people to select one or more years, months, quarters, etc...

Any advice would be greatly appreciated. 

1 Solution

Accepted Solutions
Not applicable

How to Sum, allowing only one field to filter....

Hi there,

If you want to stop something from filtering the data you do this in the set expression.  So, for example:

Sum(Spend_Amount)  

sums all filtered data

Sum(  {<location=, cost_center=>} Spend_Amount)

sums all spend amount and is not changed by the location or cost_center drop downs.

Hope that helps.

Gareth

3 Replies
christian77
Valued Contributor

Re: How to Sum, allowing only one field to filter....

Hi:

Check help, set analysis.

SUM({$<Field={'DesiredValue'}>} SPEND_AMOUNT)

or may be

SUM({1<Field={'DesiredValue'}>} SPEND_AMOUNT)

to avoid other selections

Ok.

Not applicable

How to Sum, allowing only one field to filter....

Hi there,

If you want to stop something from filtering the data you do this in the set expression.  So, for example:

Sum(Spend_Amount)  

sums all filtered data

Sum(  {<location=, cost_center=>} Spend_Amount)

sums all spend amount and is not changed by the location or cost_center drop downs.

Hope that helps.

Gareth

Not applicable

How to Sum, allowing only one field to filter....

Thank you very much, this worked like a charm.  You just saved me at least half a day of looking around and trial and error. 

Community Browser