topic Re: Values On Row Total in QlikView

Values On Row Total

tamilarasu — Wed, 30 Dec 2015 05:47:57 GMT

Hi All,

I have an excel file which filled with Region, Country and Target data. I need to show target value for region wise (from excel source) like below. I have used dimensionality() function but I could not achieve what I need. Instead of banging my head, I just posted here.

I have attached sample file. Any help would be much appreciated.

Re: Values On Row Total

tresB — Wed, 30 Dec 2015 05:58:18 GMT

Try:

If(Dimensionality()<=1, Avg({<RegionId={'>0'}>}Target),Sum({<RegionId={'>0'}>}Target))

Re: Values On Row Total

tamilarasu — Wed, 30 Dec 2015 06:05:12 GMT

Hi Tresesco,

The above expression will show average for the specific region. But, my requirement is different. I need to show region wise target which is already defined (from the above attached excel file). We have Country target and region target separately. Check the below screenshot

Re: Values On Row Total

Kushal_Chawda — Wed, 30 Dec 2015 06:13:17 GMT

try this

If(Dimensionality()<=1, avg(Target),Sum(Target))

Re: Values On Row Total

tamilarasu — Wed, 30 Dec 2015 06:18:10 GMT

Hi Kush,

As I already mentioned, I need to show defined region wise target (see excel file) and not average of the countries. Do you know any idea.!!

Re: Values On Row Total

tresB — Wed, 30 Dec 2015 06:27:44 GMT

This?

If(Dimensionality()=0, Only({<Region={'Over all'}>}Target),

If(Dimensionality()=1, Aggr(Only({1-<RegionId={'*'}>}Target),Region),

Sum({<RegionId={'>0'}>}Target))

)

Re: Values On Row Total

tamilarasu — Wed, 30 Dec 2015 06:48:44 GMT

Great and Thanks!!

Re: Values On Row Total

Kushal_Chawda — Wed, 30 Dec 2015 06:51:30 GMT

great. tresesco the champ

Re: Values On Row Total

Wed, 30 Dec 2015 07:01:21 GMT

Try this expression,

=If(RowNo()= 0 , Sum(RegionTarget), Sum(Target))

Re: Values On Row Total

Wed, 30 Dec 2015 07:05:49 GMT

in presentation tab select show partial sum for Region, country, region id

and select subtotals on top