topic Re: filter in QlikView

filter

srujanaponnuru — Fri, 03 Jul 2015 12:49:23 GMT

Hi,

I have the following data in excel as below:

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

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 — Fri, 03 Jul 2015 15:34:28 GMT

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

Sum([Market Value])

let me know

Anonymous — Fri, 03 Jul 2015 15:39:18 GMT

Hi,

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

Regards.

maxgro — Fri, 03 Jul 2015 15:47:31 GMT

first load the data in qlikview

menù --> file --> edit script

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

reload (ctrl-R)

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 — Sat, 04 Jul 2015 18:59:38 GMT

Hi Srujan,

In u r pivot table

Dimension : Category

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

sum([Market Value])