topic SUM Problem qlikview 8-9 in QlikView

SUM Problem qlikview 8-9

Wed, 21 Jul 2010 14:13:57 GMT

Hi,

why this command work fine on qlikview 9, but it doesn't work on qlikview 8?

Sum ({<anno_ven={2010}>} val_tot_ven)

What can I use on qlikview 8?

Thanks

Rocco

SUM Problem qlikview 8-9

Wed, 21 Jul 2010 14:17:30 GMT

Try to use full syntax:


Sum ({$ <anno_ven={"2010"}>} val_tot_ven)

SUM Problem qlikview 8-9

Wed, 21 Jul 2010 14:21:54 GMT

It does not work 😞

Thanks

Rocco

SUM Problem qlikview 8-9

Wed, 21 Jul 2010 14:26:41 GMT

Try

Sum (if(anno_ven=2010,val_tot_ven))

Anders

SUM Problem qlikview 8-9

Wed, 21 Jul 2010 14:38:44 GMT

Thanks, this works fine, but this is the complete expression

Sum({<mese_ven={$(=GetFieldSelections(mese_att_fat, ',', 12))}, anno_ven={$(=GetFieldSelections(anno_pre_fat))}>} val_tot_ven)

This work fine, but this is the complete expression.

Sorry

Rocco

SUM Problem qlikview 8-9

Fri, 23 Jul 2010 13:17:32 GMT

Hi,

anyone knows how help me?

Thanks
Rocco

SUM Problem qlikview 8-9

llauses243 — Mon, 26 Jul 2010 12:05:25 GMT

Can be ...

1.- Sum({<mese_ven={$(=GetFieldSelections(mese_att_fat, ',', 12))}, anno_ven={$(=GetFieldSelections(anno_pre_fat))}>} , val_tot_ven) // see comma

2.- anno_pre_fact //exist?

3.- anno_pre_fact //contains only an value ? else to use separator

good luck