topic Re: Immediate months count in QlikView

Immediate months count

Wed, 25 Nov 2020 16:16:04 GMT

I want to show next immediate month count and second and third month when DOJ>targetdate...

Please find below attachments...

Re: Immediate months count

Anil_Babu_Samineni — Wed, 08 Mar 2017 08:02:39 GMT

May be this?

If(DOJ > tagetdate, Sum({<Month = {'$(=AddMonths(Month(Today()),1))'}>}Sales) as nextimmmonth

If(DOJ > tagetdate, Sum({<Month = {'$(=AddMonths(Month(Today()),2))'}>}Sales) as second

If(DOJ > tagetdate, Sum({<Month = {'$(=AddMonths(Month(Today()),3))'}>}Sales) as third

Re: Immediate months count

Wed, 08 Mar 2017 08:07:38 GMT

Anil, that is already I have tried.. not working...

Anymore suggestions???

Re: Immediate months count

Wed, 08 Mar 2017 08:22:54 GMT

I want month wise saperate count as I showed in my snap shot

Re: Immediate months count

Anil_Babu_Samineni — Wed, 08 Mar 2017 08:26:17 GMT

Which snap you are talking about? You attached three images which one we need to look. If possible can you create dummy data and show how you want to look, Please

Re: Immediate months count

avinashelite — Wed, 08 Mar 2017 08:28:00 GMT

You need this at the script level ?

Re: Immediate months count

Wed, 08 Mar 2017 08:29:53 GMT

That's my dummy data and my desired output is showed colors with f1,f2 and f3.

Pls suggest

Re: Immediate months count

Wed, 08 Mar 2017 09:00:21 GMT

I got strucked ...Pls help

Re: Immediate months count

Anil_Babu_Samineni — Wed, 08 Mar 2017 09:05:16 GMT

Try to create data and show me where you want to do

In your image, I've seen f1+f2+f3

Sum(TOTAL f1) + Sum(TOTAL f2)+ Sum(TOTAL f3)

What are the formula you have for f1, f2, f3. How do you get 38 for f1, 43 for f2, 21 for f3 ???

Re: Immediate months count

Wed, 08 Mar 2017 09:28:59 GMT

I can't create data now so that I shared my snapshot of desired output.

Pls find this below for your reference.

Re: Immediate months count

Wed, 08 Mar 2017 10:03:59 GMT

Pfa for ur reference