topic Re: set analysis issue in QlikView

set analysis issue

souadouert — Thu, 23 Nov 2017 17:13:05 GMT

i used this expression:

SUM({<SITUATION={"=<$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND)

always it return 0 , but when i change the expression

SUM({<SITUATION={"=$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND)

it works correctly but i need to sum all productio_volume_tnd when situation <= $situation

Re: set analysis issue

Anil_Babu_Samineni — Thu, 23 Nov 2017 17:16:14 GMT

May be interplace the logic for =< to <=, Try this?

SUM({<SITUATION={"<=$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND)

Re: set analysis issue

souadouert — Thu, 23 Nov 2017 17:17:11 GMT

hello anil , i interplace the logic but always the same problem

Re: set analysis issue

Anil_Babu_Samineni — Thu, 23 Nov 2017 17:19:45 GMT

What format you have for SITUATION? And what logic you need to apply here. Because Date#(SITUATION) returns only Dates not the logic. May be you need some setup like Max() and Min() over Date#()..

Re: set analysis issue

souadouert — Thu, 23 Nov 2017 17:19:57 GMT

can i use this express

SUM({<DATE#(SITUATION)={"<=$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND) ??????????

Re: set analysis issue

souadouert — Thu, 23 Nov 2017 17:20:49 GMT

i need to sum all sales before selection situation (DATE) : 2017-10 for example

Re: set analysis issue

Anil_Babu_Samineni — Thu, 23 Nov 2017 17:25:42 GMT

can i use this express

SUM({<DATE#(SITUATION)={"<=$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND) ??????????

NO, You can't

souad ouertani wrote:

i need to sum all sales before selection situation (DATE) : 2017-10 for example

SUM({<SITUATION={"<=$(=Date#(Max(SITUATION)))"}>}PRODUCTTION_VOLUME_TND)

Re: set analysis issue

souadouert — Thu, 23 Nov 2017 17:27:37 GMT

i tried this expression but not works , i know the problem with situation because it concidere the situation as String and not Date

Re: set analysis issue

Anil_Babu_Samineni — Thu, 23 Nov 2017 17:30:46 GMT

First, You may work with Date Formats using? Can you explain the Date format?

Re: set analysis issue

souadouert — Thu, 23 Nov 2017 17:34:42 GMT

mm-yyyy

Re: set analysis issue

Anil_Babu_Samineni — Thu, 23 Nov 2017 17:38:19 GMT

Try this?

SUM({<SITUATION={"<=$(=Max(SITUATION))"}>}PRODUCTTION_VOLUME_TND)

SUM({<SITUATION={"<=$(=Date(Max(SITUATION), 'MM-YYYY'))"}>}PRODUCTTION_VOLUME_TND)

Re: set analysis issue

sunny_talwar — Thu, 23 Nov 2017 22:53:25 GMT

Is SITUTATION read as a date field from the script? If not, I would suggest to make sure that it is read as date like this

Date(MonthStart(Date#(SITUATION, 'MM-YYYY')), 'MM-YYYY') as SITUATION

One you have this, you can try this

Sum({<SITUATION = {"<=$(=Date(Max(SITUATION), 'MM-YYYY'))"}>} PRODUCTTION_VOLUME_TND)

Make sure < is before =

<= Right

=< Wrong

Re: set analysis issue

MarcoWedel — Thu, 23 Nov 2017 23:59:06 GMT

Hi,

one alternative solution might be

The As-Of Table

hope this helps

regards

Marco