Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

set analysis issue

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

12 Replies

Re: set analysis issue

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

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


souadouert
Contributor III

Re: set analysis issue

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

Re: set analysis issue

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#()..

souadouert
Contributor III

Re: set analysis issue

can i use this express

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

souadouert
Contributor III

Re: set analysis issue

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

Re: set analysis issue

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)


souadouert
Contributor III

Re: set analysis issue

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

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

souadouert
Contributor III

Re: set analysis issue

mm-yyyy

Community Browser