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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression according to fields selected

I have to multiply a value according to the number of months selected:

Months selected: January and February

Amount_bgt: Amount * 2

The problem is that i have this amount compared in a table with another amount (real_amount), since the real_amount  has only data in February, the Amount_bgt gest multiplied only by 1.

Anyone can tell me how to fix this?

Thanks!

Labels (1)
3 Replies
MayilVahanan
MVP
MVP

Hi

Use GetselectedCount(Month) and stored it as variable and then use it..

vSelectedCount = GetselectedCount(Month)

Then use like this

Sum(AMOUNT) * vSelectedCount

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Doesn't work...still appears the value as 1:

Month is Mes, as you can see i have 2 months selected

qv2.JPG

qv1.JPG

MayilVahanan
MVP
MVP

Hi

Can you able to post a sample file.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.