Total for rows (Date range) - Qlik Community

Report Inappropriate Content · ‎2016-06-19

I need help how to in QlikView for pivot, add column with (total) sum for rows, it is necessary for the dates from 01/01/2016 to 01/31/2016?
See pics

vikasmahajan · ‎2016-06-20

While loading script create field with rowno() as cnt , then use count(cnt) in pivot.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2016-06-20

thanks for the answer, I do not understand on what you mean, can you give me an example of code to write what you think?

Report Inappropriate Content · ‎2016-06-20

Use in pivot

Load in script

Result
Please help?!

Anonymous · ‎2016-06-20

Hi Zeljko,

Use dimensionality and secondarydimensionality() functions.

Something like this:

If(Dimensionality() = 1 and SecondaryDimensionality()=0,Cound(Distinct Date),YourExpression)

Regards!!!

Report Inappropriate Content · ‎2016-06-22

Thanks a lot, helped me all the answers, I succeed to find a solution with this code:
=aggr(NODISTINCT num(sum({<mesec={[1]}>}masa)),sifra)