Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Logical expression inside main expression

Hi. I'm trying to build some expression which should be calculated by logical terms.

my way1:

=sum({<Period1={'>=$(=min(Period0)) <=$(=max(Period0))'}>} Counter)

my way2:

=sum({$<Period1= {'$(=Period0)=(=Period1)'}>} Counter)

i'm trying to do something like this:

sum({$<OrderDate = DeliveryDate>} Sales) - from help of set analysis

but it's not working...

Period1 and Period0 it's dimensions.

When i using in chart my first Period1 dimension all working okay. But when i trying to use the second - damn.

=sum({<Period1={'>=$(=min(Period0)) <=$(=max(Period0))'}>} Counter)

my logic is:

IF Period1=Period0 THEN I TAKES RECEIVED DATE INTO Period1 AND THEN COUNTING FOR THAT DATE.

Help if it's possible )) thnx

4 Replies
giakoum
Partner - Master II
Partner - Master II

actually this looks quite Ok :

=sum({<Period1={'>=$(=min(Period0)) <=$(=max(Period0))'}>} Counter)

Try changing single with double quotes or else please post a sample application.

er_mohit
Master II
Master II

coun({1<Period1=P(Period0)>}Counter)

Not applicable
Author

=sum({1<Period1= P(Period0)>} Counter)

Not applicable
Author

sum({<OrderDate = {$(DeliveryDate)}>} Sales)