topic Re: Total for rows (Date range) in QlikView

Total for rows (Date range)

Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 20 Jun 2016 05:05:50 GMT

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

Vikas

Mon, 20 Jun 2016 08:54:00 GMT

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?

Mon, 20 Jun 2016 09:06:09 GMT

Use in pivot

Load in script

Result
Please help?!

Anonymous — Mon, 20 Jun 2016 09:21:57 GMT

Hi Zeljko,

Use dimensionality and secondarydimensionality() functions.

Something like this:

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

Regards!!!

Wed, 22 Jun 2016 12:52:52 GMT

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)