Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
enriquelopez88
Contributor
Contributor

Totals Not Showing in Filtered by Expression Table

Hello everyone, 

I have a problem with a table not showing Totals for measures.

The table is filtered through an expression on each of the dimensions and measures where if a field (we'll call "Project Status") has a value "3" or "5" it should return '' (Empty or Null)

Yet, when I do that, the Totals for the projects that do show up after applying the expression, do not work. It shows amounts and values for each row, but not for the Totals.

I understand I am messing with the Measures amounts by using '' as one of the returning values, but is there any other way I can filter the table without the user having to apply a filter from a Filter Pane or a Button or else?

------------------------------------------------------------------------

This is just an example of what is put as expression on each of the fields of my table:

[Project Status] is the filed by which I apply the filter depending on its value.

[Saving ID] is the field value that is displayed at the table depending on the below conditions:

 

= if([Project Status] = '0 - Not Started', [Saving ID],
       if([Project Status] = '1 - On Hold by Geodis', [Saving ID],
              if([Project Status] = '2 - In Progress', [Saving ID],
                     if([Project Status] = '3 - Cancelled', null(),
                            if([Project Status] = '4 - Implemented', [Saving ID],
                                   if([Project Status] = 'X - On Hold by Customer', [Saving ID],
                                          if([Project Status] = '5 - Savings Terminated', null()
                                          )
                                   )
                            )
                     )
              )
       )
)

-----------------------------------------------------------

Thanks for your help.

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Could you please post a screenshot of your chart? I'm confused as to what your goal is.  If I want to exclude project statuses 3 and 5, i would code a measure like this: (for example, to sum "RecordedHours" field):

Sum(
{<[Project Status -= {'3 - Cancelled', '5 - Savings Terminated'}>}
RecordedHours)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Could you please post a screenshot of your chart? I'm confused as to what your goal is.  If I want to exclude project statuses 3 and 5, i would code a measure like this: (for example, to sum "RecordedHours" field):

Sum(
{<[Project Status -= {'3 - Cancelled', '5 - Savings Terminated'}>}
RecordedHours)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

enriquelopez88
Contributor
Contributor
Author

@rwunderlich thanks a lot for the quick response!

It worked quite well.

The table now has the filter at the dimensions as I put it above, and for the measures I used the one you kindly wrote here.

Mi goal was that the list of projects I had only shown the mentioned statuses. But when doing that for the measures, it throwed me no values: "-"

Now, it does show a value at the measures and is exactly what I needed.

Sorry for the "editing" on the image, but I handle some sensitive data here.

Nonetheless, we can now see at the Totals that there are values in the last three columns. That's the expected result!😁

TableResult.jpg

Hope its of use for anyone else!