Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

Calculate amount of last invoice of each customer before a selected month

Hello

Can someone tell me how the firstsorted value is used?

I have a pivot table with Customer as dimension

I want to display for each customer the max InvoiceNumber before this month as well as the calculate the sum of the amount of each of last invoice number

Please advise

I can walk on water when it freezes
10 Replies
sunny_talwar

Would you be able to share some raw data with the expected output to help you better? It will be pure guesswork without a sample as its difficult to understand what you are trying to get

ali_hijazi
Partner
Partner
Author

check attached document

Actually I'm trying to find the value of the last invoice of each customer not served in the selected month

hope you can help me in this

I'm able to get  the customers not served and the maximum invoice before october 2016

but How I can get the value of the last invoice of each customer not served ; I'm not able to

please advise

I can walk on water when it freezes
elena888
Specialist
Specialist

Like this?

Let me know!

ali_hijazi
Partner
Partner
Author

your document doesn't open it gives the following error

not_opening.png

I can walk on water when it freezes
elena888
Specialist
Specialist

I dont' not why.

Maybe this one?

sunny_talwar

Just as a confirmation, I was able to open both the qvws attached by elena888

ali_hijazi
Partner
Partner
Author

here you got the invoice number what I want is to calculate the sales amount where invoice number is the one you got

How can I get the invoice number in set analysis?

i.e. sum of valueusd where invoice is the last one for each customer I have

I can walk on water when it freezes
elena888
Specialist
Specialist

You can create a variable with the expression of "Last" and then use in the set analysis of the Sum.

Something like this...

ali_hijazi
Partner
Partner
Author

No no

you created the variable with an equal sign at the beginning

and this will give the sum for one invoice number which is the max

what I want is to calculate the sum for the last invoice of each customer not one only last Invoice as in your suggestion

I can walk on water when it freezes