topic Re: expression in QlikView

expression

upaliwije — Wed, 10 Jul 2019 06:20:19 GMT

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.

Re: expression

Vegar — Wed, 10 Jul 2019 06:34:06 GMT

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

Re: expression

jfkinspari — Wed, 10 Jul 2019 06:39:47 GMT

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.

Re: expression

upaliwije — Wed, 10 Jul 2019 06:59:45 GMT

Thanks I got your point