Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one excel sheet As.
Customer | Material | CostPrice | Total |
---|---|---|---|
1 | A | 10 | |
2 | B | 10 | |
3 | C | 20 | |
4 | D | 30 | |
5 | A | 20 | |
6 | B | 10 | |
7 | C | 11 | |
8 | D | 23 |
Input Box |
---|
50 |
Here i want to calculate Total value based on one input box. If value in input box is 50 then i want to calculate total as 50*CostPrice.
If i directly enter Formula 50*Costprice in Total column definition. it is working for all rows. But if i use material filteration
means i selected material A then 1,5 customers has this material and i want to update these 2 rows with input box value 80 then i am getting total as 80*10 and 80*20. this is fine
but if i unselect the material A from filtration (with intention to see all materials ).This 80 value is applying to all materials.
Is there anyway to handle this ?
Regards,
Praveen
Dear Praveen,
I am sorry but i couldn't get your problem, can you please explain with example and the sample data if possible.
Regards,
Kaushik Solanki
Hi Kaushik,
Thanks for your reply. For easy understanding i modified column names. Please check the attached video. here problem is at last step after material de-selection input box value is applied to New rebate column.
I can't insert the video here, please check below link it has video file
http://community.qlik.com/thread/98264
Regards,
Praveem