topic Re: Set Expression in QlikView

Set Expression

VishalWaghole — Thu, 08 Aug 2013 08:57:50 GMT

Hi Community,

I have one pivot table with 3 expression

1. sum(amount)

2. sum(amount1)

3. sum(amount)/sum(amount1)

and at the bottom line i have Total of all this columns.

My sum(amount) and sum(amount1) giving me correct Total but

My sum(amount)/sum(amount1) total giving me incorrect total coz of my set expression.

so how can we develope set expression those giving me columns total.

Thanks.

Re: Set Expression

Thu, 08 Aug 2013 09:01:22 GMT

sum(amount/amount1)

Re: Set Expression

Thu, 08 Aug 2013 09:02:31 GMT

also try this

sum(sum(amount)/sum(amount1))

Re: Set Expression

VishalWaghole — Thu, 08 Aug 2013 09:23:59 GMT

i have already tried this but that was not giving me row level output.

Means if i have amount as 100 and amount1 as 25 then 3rd column gives me 4.

Thanks for reply

Re: Set Expression

VishalWaghole — Thu, 08 Aug 2013 09:24:58 GMT

Thanks vishwaranjan.

I tried this but that was given me output as null values.

Re: Set Expression

MayilVahanan — Thu, 08 Aug 2013 09:29:47 GMT

Try like this

= Column(1)/Column(2)

Hope that helps

Re: Set Expression

VishalWaghole — Thu, 08 Aug 2013 09:32:46 GMT

= Column(1)/Column(2)

that gives me row level output but at the bottom i want Total of that Column

Thanks

Re: Set Expression

Thu, 08 Aug 2013 09:37:23 GMT

ok try this

sum(total amount/ amount1)

Re: Set Expression

MayilVahanan — Thu, 08 Aug 2013 09:41:49 GMT

can u post a sample file? with ur expecting answer?

Re: Set Expression

VishalWaghole — Thu, 08 Aug 2013 10:02:08 GMT

PFA.

see my last expression column.

i want only Total at Bottom.

Thanks

Re: Set Expression

VishalWaghole — Thu, 08 Aug 2013 10:09:32 GMT

I tried this but that returns zeros.

Thanks

Re: Set Expression

er_mohit — Thu, 08 Aug 2013 13:03:08 GMT

ok try this expression

if(Dimensionality()=1,(sum(TOTAL amount)/sum(TOTAL amount1))

or if you want Total On every Row then try this simply

sum({1} amount)/sum({1} amount1)