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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

why impossible? get value from dimension with some expression

Hi!

I have List Box with only 1 field and this field is expression:

=aggr(sum({< bg_t={'*'}, bg_t-={'w\o'}, Holding=>} AmountWVAT),AffiliateID,Holding,month)

i want fill my array with exacly this data

is it posible?

Labels (1)
3 Replies
sivarajs
Specialist II
Specialist II

Try this aggr(sum({< bg_t={'*'}-{'w\o'}, Holding=>} AmountWVAT),AffiliateID,Holding,month)

Not applicable
Author

hi!

i need fill array with macro like filling array from field: set val=ActiveDocument.Fields("Sale").GetSelectedValues

but i dont nedd all field, i need my result values

Not applicable
Author

solve using by GetCell