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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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?

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