Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

any one can help i want to display table like this

name  month  amount

a         aug      500

a         sep      500

a         oct       500

a         nov       500

-------------------------------

total                2000

i want to display table like this

name  month  amount

a         aug      2000

a         sep      1500

a         oct       1000

a         nov       500

-------------------------------

total                0

4 Replies
qliksus
Valued Contributor

Re: any one can help i want to display table like this

Hi,

try this

sum

(total amount)- rangesum(above(sum(amount),1,rowno()))

SunilChauhan
Esteemed Contributor

Re: any one can help i want to display table like this

see the attached file

Not applicable

any one can help i want to display table like this

For one employee its ok

but i want show as below

My sourse  is below
NameMonthAmount
XAug500
XSep500
XOct500
XNov500
XDec0
XXAug500
XXSep400
XXOct300
XXNov300
XXDec0
I want to show
Month   X       XX
Aug20001500
Sep15001000
Oct1000600
Nov500300
Dec00


Regards

Sankar

any one can help i want to display table like this

HI,

    Create a pivot chart with dimensions as Month, Name and expression as Sum(values)

    Now you can drag the Name field as take it to the above of the expression.

    Hope this helps.

Regards,

Kaushik Solanki