topic Totals Not Showing in Filtered by Expression Table in App Development

Totals Not Showing in Filtered by Expression Table

enriquelopez88 — Mon, 07 Mar 2022 20:55:05 GMT

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.

Re: Totals Not Showing in Filtered by Expression Table

rwunderlich — Mon, 07 Mar 2022 23:18:07 GMT

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

Re: Totals Not Showing in Filtered by Expression Table

enriquelopez88 — Mon, 07 Mar 2022 23:47:04 GMT

@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!😁

Hope its of use for anyone else!