filter

[srujanaponnuru]

Hi,

I have the following data in excel as below:

Category	Market Value
Level 1 Assets	43395
Level 1 Assets	96387
Level 1 Assets	44997
Level 2 Assets	64799
Level 2 Assets	28817
Level 2 Assets	78013
Non-Qualifying Assets	61553
Non-Qualifying Assets	14771
Non-Qualifying Assets	79524

i want the pivot table or straight table outpput in qlikview as below:

Category	Market Value
Level 1 Assets	184779
Level 2 Assets	171629
Non-Qualifying Assets	155848

Here the market values are total of level 1 assets and total of level 2 assets similarly for Non-qualifying assets.

Please help me out to do this in qlikview scripting or how to write expressions as i am very new to qlikview.

Thanks

Srujana

[alexandros17]

Load the Excel file then create a pivot, use "category" as dimension and add an expression:

Sum([Market Value])

let me know

[Anonymous]

Hi,

I hope this can help you (I do this with expression).

Regards.

[maxgro]

1)

first load the data in qlikview

menù --> file --> edit script

use table files button to create the script with the file wizard

2)

reload (ctrl-R)

3)

make the chart

for pivot chart you can use the wizard

menù --> tools --> quick chart wizard --> pivot table -->

choose the first dimension --> category

choose the expression --> sum  Market Value

[ramasaisaksoft]

Hi Srujan,

In u r pivot table

Dimension : Category

Expression:=aggr(sum([Market Value]),category)

                             or

                            sum([Market Value])