topic Articleprice changed in QlikView

Articleprice changed

wunderch — Thu, 03 Aug 2017 06:00:05 GMT

Hi guys,

I have the following problem:

I have a table with Date, Article, Price regular and Price supply. (like xlsx)

Now I want to get only Article shown in a table, who have the same "Price supply" since more then 55 days. (like Article 1234)

How can I get this? With Script or Expression in the table?

Please help, I'm frustrated!

Regards

Christian

Re: Articleprice changed

antoniotiman — Thu, 03 Aug 2017 06:34:44 GMT

Hi Christian,

You can try

Only({<Date={'>=$(=Date(Today()-55))'}>} [Price supply])

Regards,

Antonio

Re: Articleprice changed

micheledenardi — Thu, 03 Aug 2017 06:53:44 GMT

I've create a new field that count how many times the Price Supply is equal to its previous record and it works fine:

MainTable:
LOAD Date, 
     Article, 
     [Price regular], 
     [Price supply],
     if(peek([Price supply])=[Price supply],peek(Count)+1,1) as Count
FROM
[Price regular vs Price supply.xlsx](ooxml, embedded labels, table is Tabelle1);

Re: Articleprice changed

ahaahaaha — Thu, 03 Aug 2017 07:07:12 GMT

Hi,

May be like this

If(Count(Aggr(DISTINCT Sum({<Date={">=$(=Date(Max(Total <Article> Date)-55))"}>} [Price supply]), Article, [Price supply]) )=1, [Price supply])

Example at attached file.

Regards,

Andrey

Re: Articleprice changed

wunderch — Fri, 04 Aug 2017 11:04:15 GMT

Hi Andrey,

that's it.

Thanks for your quick answer.

Regards,

Christian

Re: Articleprice changed

ahaahaaha — Fri, 04 Aug 2017 11:23:18 GMT

Was glad to help you

Regards,

Andrey