topic Re: set analysis problem in QlikView

set analysis problem

adiarnon — Tue, 11 Mar 2014 07:12:08 GMT

whats wrong in this expression:

Sum({<Month={'<=month(today())'}>}Target_Product)

i want the sum of Target_Product till the end of the month

tnx.

Re: set analysis problem

tresB — Tue, 11 Mar 2014 07:18:08 GMT

Try like:

Sum({<Month={"<=$(=month(today()))"}>}Target_Product)

Re: set analysis problem

adiarnon — Tue, 11 Mar 2014 07:30:14 GMT

tnx

but its not working... =/

Re: set analysis problem

tresB — Tue, 11 Mar 2014 07:31:37 GMT

I guess the month data format could be the issue. Could you post your sample app?

Re: set analysis problem

adiarnon — Tue, 11 Mar 2014 07:33:25 GMT

this expression works:

=Sum({<Month={"=(month(today()))"}>}Target_Product)

gives only the target of the current month

Re: set analysis problem

Tue, 11 Mar 2014 08:21:23 GMT

Adi,

When using month() function, it will return Feb, Oct according to your parameters. = is OK, <= is not.

You should do num(month(today()))

When you perform date comparison, you should use numeric.

Fabrice

Re: set analysis problem

PrashantSangle — Tue, 11 Mar 2014 08:43:42 GMT

Hi,

Use proper function name inside ""

Like use =Month(Today())

Re: set analysis problem

tresB — Tue, 11 Mar 2014 09:08:38 GMT

This has given a new finding:

Fabrice Aunez , comparison works (because with Month() the output is actually a dual), but with a different style:

=Sum({<Month={"=Month>Month(Today())"}>}Amt) // Set analysis example

=Sum(If(Month>Month(today()),Amt)) // If

So, adi arnon, this : Sum({<Month={"=Month<=Month(Today())"}>}Target_Product) , would work for you.

PFA

Re: Re: set analysis problem

Tue, 11 Mar 2014 09:46:45 GMT

Tresesco,

I partially agree.

These two syntaxes work:

sum ({<Month ={"<= $(=num(month(today())))"} >} Amount)

sum({<Month ={"=Month<Month(today()) "} >} Amount)

This syntax does not work (I do not get any result): The only difference with the first syntax is the num() function that is not used.

sum({<Month ={"<= $(=month(today()))"} >} Amount)

Month is dual: it has been constructed using the Month() function.

In set analysis, I think it is better to use numeric for date comparisons. But (you are right) that is not the single way.

Fabrice

Re: set analysis problem

adiarnon — Tue, 11 Mar 2014 11:41:53 GMT

i tried this:

=Sum({<Month={"<=$(month(today()))"}>}Target_Product)

its giving me the target of the whole year. nit just till this month

help please

Re: set analysis problem

PrashantSangle — Tue, 11 Mar 2014 11:48:59 GMT

Hi,

Looks like you are missing = in expression

Sum({<Month={"<=$(=Month(Today()))"}>}Target_Product)

Re: set analysis problem

Tue, 11 Mar 2014 11:49:32 GMT

There are several syntaxes to test. See above all threads and their explanations

Fabrice

Re: set analysis problem

sunilkumarqv — Tue, 11 Mar 2014 11:58:17 GMT

Try this sorry for previous one

=Sum({<Month={"=(Month>(Month(today())))"}>}Target_Product)