topic Re: Logical expression inside main expression in QlikView

Logical expression inside main expression

Tue, 07 May 2013 09:55:32 GMT

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

giakoum — Tue, 07 May 2013 10:00:37 GMT

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 — Tue, 07 May 2013 10:11:28 GMT

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

Tue, 07 May 2013 10:28:52 GMT

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

Tue, 07 May 2013 10:34:35 GMT

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