Re: Aggregation to show a relative percentage to t... - Page 2 - Qlik Community

Anonymous · ‎2018-04-16

Hello,

I have a problem with using a aggregation for constructing a relative percentage of the row value tot the total of the rowvalues.

I have uploaded a data file and a qvw file with a exeample to make it clear.
You will find some dimensions and data columns in the data file.

In the added screenshots of the app is the month apr17 selected.

The problem is that the value of the aggegation expressions is shown only on the total row or on one row of the table that is selected.

(see screenshot)

Clicking on another row makes the aggrgation appear at this row.(see screenshot ).

Any suggestions ? Thanks for your help in advance.

Regards

Wim Steskens

sunny_talwar · ‎2018-04-18

I am a little confused, what exactly are you trying to get? Can you share the expected output in an Excel file for me?

Anonymous · ‎2018-04-18

Sunny,

Sorry that I confused you, that wasn’t my goal. ☺

I attached a Excell-file.

The goal is to have a pivot table like the last one in the Excell-file (background is yellow).

with celvalues per months (=dimension03 in the previous qvw-file) per Verzuimduurklasse (=dimension03 in the previous qvw-files)

The celvalue is the relative percentage of the value of Expr divided by Agr (colums in the previous qvw-files).

This is not a problem.

The problem is to also show the total of the celvalue ( %rel) over the selected months.

Hope this makes it clear.

Regards,

Wim Steskens

Van: Sunny Talwar

Verzonden: woensdag 18 april 2018 10:58

Aan: W.H.M. (Wim) Steskens <w.steskens@leeuwenborgh.nl>

Onderwerp: Re: - Aggregation to show a relative percentage to the total

sunny_talwar · ‎2018-04-18

Here you go

Anonymous · ‎2018-04-23

Sunny,

That’s it what I was looking for.

Thanks again for your great help.

Regards,

Wim Steskens

Van: Sunny Talwar

Verzonden: woensdag 18 april 2018 13:40

Aan: W.H.M. (Wim) Steskens <w.steskens@leeuwenborgh.nl>

Onderwerp: Re: - Aggregation to show a relative percentage to the total

sunny_talwar · ‎2018-04-23

I am glad I was able to help.

Best,

Sunny