topic Re: straight table qoute over two columns in QlikView

straight table qoute over two columns

Zeljko — Sat, 16 Nov 2024 02:19:57 GMT

Hi,

I have a problem to calculate the qoute over two colums in a straigt table.
The problem is that a master of a department have more teamleaders and for the teamleaders there are same people which work for more teamleaders not only for one. In my fact Table I create this relations.
The first 3 Colums in the Table 2 are right calculated but I can not calculate the Column 4 ("KRANK Qu % Gesamt").
The expression for this ist Column 3 ("Krank Gesamt") / Column 2 ("SOLL"). The rigtht Value forthe total line should be
16 / 2705 = 0.0059 --> 0.59%.
Can any one help me to find a right expresion for this issue?

Example qvw "Abwesenheitsstatistik_TEST.qvw" see attachment.

Thank you for help.

Zeljko

Re: straight table qoute over two columns

StarinieriG — Wed, 02 Oct 2019 12:13:47 GMT

Hi,

you have to use aggr

Sum(Aggr(if(len(Only(PERS_TLName))>=1,sum(SumKrank),sum(distinct SumKrank)),PERS_KRANKM))/Sum(Aggr(if(len(Only(PERS_TLName))>=1,sum(SumSOLL),sum(distinct SumSOLL)),PERS_KRANKM))

Re: straight table qoute over two columns

Zeljko — Thu, 03 Oct 2019 05:59:54 GMT

Thank you!

It works now!

Best Regards
Zeljko