Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Last purchase date and price

Hello,

i have a table_chart that looks like this

ItemID(Dimension), Date of purchase(Dimension) - Expression: Amount, QTY. I want to add Last Price and Last purchase Date.

The Line "ItemID" is connected to saleslines and via the Saleslines with the customer table. The values change when i select the buyer for whom i want the statistics.

The Expression: FirstSortedValue( Salesprice , -Date)  should give me the last price and it does. But my problems:

- Some fields(items) have "-" as a value in last price, i think its due to the fact that the Item have been sold on one day more then once?

- last purchase date isnt beeing showed at all

I would appreciate help on this matter.

The table should show every Item only once with the last date and last Price and when i select a customer it should adopt. Anybody an idea how the formula should look like?

Thank you in advance

1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

Re: Last purchase date and price

see the attached file

here it show value of last date

if you want group by then go to script side uncomment field then see the output

3 Replies
er_mohit
Honored Contributor II

Re: Last purchase date and price

see the attached file

here it show value of last date

if you want group by then go to script side uncomment field then see the output

Not applicable

Re: Last purchase date and price

Ti should always show me the "youngest" value. So when i put the filter "on" for customers, it should show me the one from the customer

Not applicable

Re: Last purchase date and price

there is none

Community Browser