expression

[upaliwije]

Hi Friends

I have developed a Qv document to get some stats for Insurance Policies and I have created a pivot table and screen shot is shown below

In my current Pivot table  last column remain 0 but I want that 0 to be 1 as shown in my second Pivot table . Kindly help correct my pivot table and I have attached my QV doc h/w plaese.

[Vegar · Accepted solution]

When Selecting Year=2016 you have no data accociated to Y1=2015. You need to adjust your expression or your data in order to get your desired output in your expression

sum({<YEAR={"$(vN2)"},Y1={"$(vN1)"},RTYPE={"REN"}>}PNOS)

When selecting 2016 no 2015 values are associatedin the data

[jfkinspari]

You don't have any records where YEAR = 2016 and Y1 = 2015, so that is why the column calculates to 0.

So either your data is different from what you expect, or you have a datamodel issue.

[upaliwije]

Thanks I got your point