Solved: Total/Dimensionality functions in pivot table. - Qlik Community

Report Inappropriate Content · ‎2015-01-20

Hi All

I have the following fields:

Category

Issue

Sum of activities.

I have a pivot table.

the 2 dimensions are Category and Issue. the expression is" sum of activities". I want that the expression will be affected only be the first dimension (Category) and not by the 'Issue' dimension. I tried to use the following function:

Count(Total<issue> activities)

But it didn't helped. maybe i should use something with Dimensionality function ?

Really appreciate your help. thanks

kuba_michalik · ‎2015-01-21

TOTAL does not concern selections, just dimension combinations in the table. See the attached example, as you can see it does ignore Issue as a dimension. But if you select a single Issue, that will still influence the result.

If you want to ignore the selection, you need set analysis. If you need to ignore both selection and dimension, you use both. I've shown all cases in the example, try selecting one or more Issue and see how it works.

(Oh, and if you really want you can try just using ALL instead of TOTAL, but that's legacy stuff, don't do it )

View solution in original post

PrashantSangle · ‎2015-01-20

Hi,

Try like

Sum({<issue=>}activities)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2015-01-20

I made a little mistake, the total function I tried to use is: Count(Total<Category> activities)

Report Inappropriate Content · ‎2015-01-20

Max thanks for your answer but unfortunately it didn't work.

kuba_michalik · ‎2015-01-20

Did it do anything at all? Because generally, yes, it should calculate the Count() as if there was only one dimension (Category) in the table. Of course there are two dimensions visually, so this result will show up under every single combination of Issue and Category for a given Category.

Could you elaborate on what effect would you like to achieve?

Report Inappropriate Content · ‎2015-01-21

Hi Jakub thanks for answering.

Lets say I have "animals" Category.

The Issues under the category are: dog, cat, fish and bird.

I want that when the table is collapsed and expanded the count of issues will always be 4 and won't be affected from the selected issue. I thought that the function total does that.

kuba_michalik · ‎2015-01-21

TOTAL does not concern selections, just dimension combinations in the table. See the attached example, as you can see it does ignore Issue as a dimension. But if you select a single Issue, that will still influence the result.

If you want to ignore the selection, you need set analysis. If you need to ignore both selection and dimension, you use both. I've shown all cases in the example, try selecting one or more Issue and see how it works.

(Oh, and if you really want you can try just using ALL instead of TOTAL, but that's legacy stuff, don't do it )

Report Inappropriate Content · ‎2015-01-21

Thank you so much!