Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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
];
Specialist III
Specialist III

Re: 2 Total

commQV79.PNG

Highlighted
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