Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!

3 Replies
MayilVahanan

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

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.