Logic help to calculate Amount on the basis of Product Price.

[lalitkgehlot89]

Hi,

In given two set of data. In First set I have Data, Product & Qty and in another set  I have Date, Product & Price.

I want to calculate Date & Product wise Amount on the basis of Product Price.

Amount Formula :- Qty*Price

But problem is that in Price data set. I have only Product Price applicable  Date.

Product P1 Price will be 100 from 01-01-2018 to 14-01-2018

                                       125 from 15-01-2018 to 03-02-2018

                                       120 from 04-02-2018 to 11-03-2018

                                        169 from 12-03-2018 to 14-03-2018  and

                                         161 from 15-03-2018 to till the next update date.

and this condition will be applied for all products.

[Sergey_Shuklin]

Hello, Lalit1

Try to use IntervalMatch function for solving such issues:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

[stabben23]

Hi,

Have a look into this QVW