topic Counting back to front in QlikView

Counting back to front

Wed, 26 Apr 2017 17:32:52 GMT

Hey guys, how are you?

Well, I have a doubt, I want to make a code that returns me something like that:

Last network day of month = 1;

Penultimate network day of month = 2 and goes on...

Sincerely, Luiz

Re: Counting back to front

Digvijay_Singh — Wed, 26 Apr 2017 18:05:42 GMT

Can you elaborate more, dimension, expression, business need etc

Re: Counting back to front

Wed, 26 Apr 2017 18:09:21 GMT

I want to show how much is sold in the end of the month, how much it represents comparing with total. but I want to choose the range for example: in the last 3 days or 4 days.

Re: Counting back to front

Digvijay_Singh — Wed, 26 Apr 2017 18:19:46 GMT

You may try with monthend function, as such -

Datefield<=MonthEnd(Datefield) and Datefield > Date(MonthEnd(Datefield)-3)

Re: Counting back to front

maxgro — Wed, 26 Apr 2017 18:46:31 GMT

if you have a calendar in your data model you can add a field with the number of days

last day of month = 1

......................... = 2

and so on

In your chart you can use set analysis to filter the n last days of month