Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SUM Problem qlikview 8-9

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

6 Replies
Not applicable
Author

Try to use full syntax:


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


Not applicable
Author

It does not work 😞

Thanks

Rocco

Not applicable
Author

Hi

Try

Sum (if(anno_ven=2010,val_tot_ven))

Anders



Not applicable
Author

Thanks, this works fine, but this is the complete expression Stick out tongue



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

Not applicable
Author

Hi,

anyone knows how help me?

Thanks
Rocco

llauses243
Creator III
Creator III

Hi

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