topic Checking for Static Data in QlikView

Checking for Static Data

Karl_Hart — Wed, 25 Nov 2020 16:16:04 GMT

I have the need to see how long prices have been at the same value

So I may have a table

Month Price

1. Jan 5.50

2. Feb 5.50

3. Mar 5.50

4. Apr 6.00

5. May 6.00

6. Jun 6.00

7. Jul 6.00

8. Aug 6.00

So in this above example we can see that the price has been at 6.00 for the last 5 months. I want to be able to calculate this figure for hundreds of different company / product combinations but I'm struggling to even begin.

I've thought about doing a big if statement saying something along the lines of

If current price = price 12 months ago then 12,

if current price = price 11 months ago then 11,

......etc etc

but this gets very big very quickly

Any thoughts?

Ultimately I want

Month Value of the last sales point (8)

Smallest month value where price = current price (4)

= 5

Re: Checking for Static Data

YoussefBelloum — Fri, 11 May 2018 15:05:57 GMT

Hi,

would you be able to add more details like the complete data structure and what is the exptected output on the dashboard ? on what type of object you to show that value ?

Re: Checking for Static Data

Karl_Hart — Mon, 14 May 2018 12:58:35 GMT

Youssef,

The end goal is for each customer / product combination I want to know how many months the sales price has been static.

Customer Product Months Since Price Rise

Cust A Prod 1 24

Cust B Prod 2 20

Cust A Prod 2 19

Cust C Prod 3 15

Cust B Prod 1 10