topic Re: 2 Total in QlikView

Difficult Req

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: 2 Total

smilingjohn — Fri, 29 May 2020 13:35:44 GMT

Hi community any help on this .

Re: 2 Total

smilingjohn — Fri, 29 May 2020 19:31:30 GMT

Hi community

Is my requirements possible in qlikview or not ?

Re: 2 Total

Saravanan_Desingh — Sat, 30 May 2020 01:00:20 GMT

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 ];

Re: 2 Total

Saravanan_Desingh — Sat, 30 May 2020 01:00:52 GMT

Re: 2 Total

smilingjohn — Sat, 30 May 2020 12:20:29 GMT

Hi @Saravanan_Desingh ,

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

Re: 2 Total

Saravanan_Desingh — Sat, 30 May 2020 14:34:02 GMT

Please find the file here.

Re: 2 Total

smilingjohn — Sat, 30 May 2020 16:26:38 GMT

@Saravanan_Desingh

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

Re: 2 Total

Saravanan_Desingh — Sat, 30 May 2020 23:59:27 GMT

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) )

Re: 2 Total

Saravanan_Desingh — Sun, 31 May 2020 00:00:54 GMT

In the Sort, use Dim.