Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
@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!