topic Re: How to show partial sum with value list. in QlikView

How to show partial sum with value list.

kavita25 — Mon, 09 May 2016 11:18:42 GMT

Hi everyone,

@Sunny T

I want to show total zone wise where I am creating Branches with value list.

Please help me with this issue.

Regards,

Kavita

Re: How to show partial sum with value list.

Gysbert_Wassenaar — Mon, 09 May 2016 11:27:01 GMT

Can you post a small qlikview document that explains what you're trying to achieve?

Re: How to show partial sum with value list.

trdandamudi — Mon, 09 May 2016 11:29:48 GMT

I am not very clear about your requirement but see if the attached will work. If not please post a small sample file:

Re: How to show partial sum with value list.

Kushal_Chawda — Mon, 09 May 2016 11:46:28 GMT

Instead of using value list try to map the Branch value in your script like below

Branchmap:

LOAD * inline [

Zone, Branch

West, A

West, B

East, C

East, D

South , E

South, F ];

Now you can create the link on Zone, so your branches will be linked to your zone and you can show partial sum easily in your pivot table

Re: How to show partial sum with value list.

HirisH_V7 — Mon, 09 May 2016 12:01:09 GMT

Hi,

Check this Sample,

If you want to classify subgroups and corresponding Branches,

Data:

LOAD * INLINE [

Subgroups, Sales

1, 12

2, 32

3, 221

4, 11

5, 11

6, 22

];

And By creating a bar chart,

Dimension:

=Valuelist('B1','B2','B3')

Expressions:

=If(ValueList('B1','B2','B3')='B1',Sum({<Subgroups={'1','2'}>}Sales))
=If(ValueList('B1','B2','B3')='B2',Sum({<Subgroups={'5','6'}>}Sales))
=If(ValueList('B1','B2','B3')='B3',Sum({<Subgroups={'4','5'}>}Sales))

Here is the Chart Acquired,

Hope this helps your Requirement,

else

post your Requirement with more details,

PFA,

Hirish

Re: How to show partial sum with value list.

kavita25 — Mon, 09 May 2016 12:39:02 GMT

PFA

Re: How to show partial sum with value list.

sunny_talwar — Mon, 09 May 2016 12:42:45 GMT

What is the logic to combine 1st 4 into one? I guess I am having difficult understanding what exactly are you looking to get?

Re: How to show partial sum with value list.

kavita25 — Tue, 10 May 2016 05:11:51 GMT

First 4 is the North Central Zone & Kolkata is categorised under East Zone..

I have made those dimensions with Valuelist as there are some conditions on the that basis Dimensions are created,you can see in the expressions.