topic Count Total Error in QlikView

Count Total Error

upaliwije — Sat, 16 Sep 2017 08:19:10 GMT

I have this issue with my Pivot table

In my following screen shot Total Nos is 12 where as actual Nos should be 4 as can bee seen in 3rd screen shot. In 2nd screen shot Nos shown as 12

My Dimension & Expression are shown below

What could be reason for the error. Pls correct where I am wrong

upaliwije — Sat, 16 Sep 2017 08:38:39 GMT

On the further I noticed that since I have 3 items in the Value List count is taken 3 times

Chanty4u — Mon, 18 Sep 2017 10:02:51 GMT

try this

vMaxYear=max(riskyear)-1;

only change the set exp

,sum({<risk_year={$(vMaxYear)}>Nnos)

Anil_Babu_Samineni — Mon, 18 Sep 2017 10:07:29 GMT

May be use

Sum({<RISK_YEAR = {"$(=AddYears(Max(RISK_YEAR), -1))"}>} Nnos)