Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Difficult Req

Hi All , 

Please find the attachment of the excel sheet , 

I want to show subtotal and Total  in a table in QlikView . 

I have Department and Category and Sales , 

As shown in the screenshot below is it possible to achive this in Qlikview ? 

 

 

Thanks in Advcance 

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

Re: 2 Total

Can you try this?

tab1:
LOAD * INLINE [
    Department , Category, Saes
    Sales, A, 10
    IT, A, 20
    HR, A, 30
    Finance, A, 10
    Sales, B, 5
    IT, B, 10
    HR, C, 15
    Finance, D, 15
];

Concatenate(tab1)
LOAD DISTINCT 'SubTotal' As Department, Category
Resident tab1;

tab2:
LOAD * INLINE [
    Department, Dim
    Sales, 1
    IT, 1
    HR, 1
    SubTotal, 2
    Finance, 3
];

Dimensions: Department & Category

Exp: 

If(Department='SubTotal', 
RangeSum(Above(total Sum(Saes) , 0, 4)),
Sum(Saes)
)

commQV80.PNG

View solution in original post

9 Replies
Highlighted
Creator III
Creator III

Re: 2 Total

Hi community any help on this .

 

Highlighted
Creator III
Creator III

Re: 2 Total

Hi community 

Is my requirements possible in qlikview or not ? 

Highlighted
Specialist III
Specialist III

Re: 2 Total

Are you looking something like this? Do you want Subtotal before Finance?

tab1:
LOAD * INLINE [
    Department , Category, Saes
    Sales, A, 10
    IT, A, 20
    HR, A, 30
    Finance, A, 10
    Sales, B, 5
    IT, B, 10
    HR, C, 15
    Finance, D, 15
];

tab2:
LOAD * INLINE [
    Department, Dim
    Sales, 1
    IT, 1
    HR, 1
    Finance, 2
];
Highlighted
Specialist III
Specialist III

Re: 2 Total

commQV79.PNG

Creator III
Creator III

Re: 2 Total

Hi @saran7de ,

How are you getting this in pivot table can you please attach the qlikview file ??? And also  after finance there should not be subtotal  . How can it be done.

Thanks 

Highlighted
Specialist III
Specialist III

Re: 2 Total

Please find the file here.

Highlighted
Creator III
Creator III

Re: 2 Total

@saran7de  

Thanks for the file , How should we remove the subtotal after Finance ?  

Highlighted
Specialist III
Specialist III

Re: 2 Total

Can you try this?

tab1:
LOAD * INLINE [
    Department , Category, Saes
    Sales, A, 10
    IT, A, 20
    HR, A, 30
    Finance, A, 10
    Sales, B, 5
    IT, B, 10
    HR, C, 15
    Finance, D, 15
];

Concatenate(tab1)
LOAD DISTINCT 'SubTotal' As Department, Category
Resident tab1;

tab2:
LOAD * INLINE [
    Department, Dim
    Sales, 1
    IT, 1
    HR, 1
    SubTotal, 2
    Finance, 3
];

Dimensions: Department & Category

Exp: 

If(Department='SubTotal', 
RangeSum(Above(total Sum(Saes) , 0, 4)),
Sum(Saes)
)

commQV80.PNG

View solution in original post

Highlighted
Specialist III
Specialist III

Re: 2 Total

In the Sort, use Dim.

commQV81.PNG