Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

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
Anil_Babu_Samineni

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

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


Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
souadouert
Specialist
Specialist
Author

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

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
souadouert
Specialist
Specialist
Author

can i use this express

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

souadouert
Specialist
Specialist
Author

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

Anil_Babu_Samineni

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)


Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
souadouert
Specialist
Specialist
Author

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

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
souadouert
Specialist
Specialist
Author

mm-yyyy