topic Re: SUB Totals in QlikView

SUB Totals

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

Hi All,

Need your help..

Please find attched table

is it possible to make sub totals llike :

a+b

a+b+c

a+b+c+e

a+b+c+d+e

it can be in strait table or pivot

Thanks

Roee

Roll	Sum
a	10
b	5
c	4
d	3
e	2

Re: SUB Totals

fkeuroglian — Mon, 08 Aug 2016 00:00:10 GMT

Hi Roee

se the attached

hope help

Fernando K.

Re: SUB Totals

sunny_talwar — Mon, 08 Aug 2016 00:33:54 GMT

Sub-totals? can you elaborate how your solution should like if what fkeuroglian‌ provided doesn't work for you?

Best,

Sunny

Re: SUB Totals

qliksus — Mon, 08 Aug 2016 04:38:15 GMT

hi,

Maybe something like this

Subtotal:
LOAD * INLINE [
    Roll,Sum
    a ,10
    b ,5
    c, 4
    d ,3
    e, 2
];

for Each a in 'ab','abc','abce','abcde'

load

*,
if( SubStringCount('$(a)',Roll),'$(a)') as Group

Resident Subtotal ;

NEXT

DROP Table Subtotal;

Re: SUB Totals

Mon, 08 Aug 2016 05:45:18 GMT

Hi Roee,

Please find the attachment, i hope it will help you.

Thank you !

Nandu

Re: SUB Totals

fkeuroglian — Mon, 08 Aug 2016 11:14:43 GMT

Nanda

Same xls

Same set expression

Same objects

Same result

Different qvw name

Really?

Re: SUB Totals

sunny_talwar — Mon, 08 Aug 2016 11:26:19 GMT

I hate when people do that

Re: SUB Totals

roee1983 — Tue, 09 Aug 2016 17:20:46 GMT

Hi,

Thank You

Which Dim and Exp did you use ?

Thanks

Roee

Re: SUB Totals

beck_bakytbek — Thu, 13 Oct 2016 08:38:21 GMT

Hi Susant,

did you do this example on the base of straight table?

thanks

beck