How to show partial sum with value list.

[kavita25]

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

[Gysbert_Wassenaar]

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

[trdandamudi]

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

[Kushal_Chawda]

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

[HirisH_V7]

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

[kavita25]

PFA

[sunny_talwar]

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

[kavita25]

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.