topic Re: set analysis expression in QlikView

set analysis expression

adiarnon — Tue, 23 Dec 2014 08:38:12 GMT

hi,

i have this expression-

=Sum({<BU_Year_Quarte>={">=(num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

it not working!!

this is working-

=Sum({<BU_Year_Quarte>={"=(num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

whats wrong?

adi

Re: set analysis expression

francoiscave — Tue, 23 Dec 2014 08:41:43 GMT

Hi Adi,

The best document to manipulate Set Analysis:

Set Analysis: syntaxes, examples

By Fabrice Aunez.

It will be helpful !

François

Re: set analysis expression

mdmukramali — Tue, 23 Dec 2014 08:47:09 GMT

Dear,

The field name is

BU_Year_Quarte

BU_Year_Quarte>

If it's BU_Year_Quarte then try to use the below expression

=Sum({<BU_Year_Quarte={">=(num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

Thanks,

Mukram

Re: set analysis expression

PrashantSangle — Tue, 23 Dec 2014 08:54:05 GMT

Hi,

Try like

=Sum({<BU_Year_Quarte>={">=$(=num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

Regards

Re: set analysis expression

adiarnon — Tue, 23 Dec 2014 09:03:33 GMT

not working

Re: set analysis expression

adiarnon — Tue, 23 Dec 2014 09:06:40 GMT

this is working-

=Sum({<BU_Year_Quarter={"=(num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

but i need

=Sum({<BU_Year_Quarter={">=(num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

and its not working,,,,

this-num(year(today())&'0'&ceil(month(Today())/3)) -> 201404

and this

=Sum({<BU_Year_Quarter={">=201404"}>}BudgetCurrentBook) -is working

whats wrong?

Re: set analysis expression

tresB — Tue, 23 Dec 2014 09:07:07 GMT

'=' works, because it is taken as a text/string comparison.

'=>' won't work( works actually as string comparison rather than numeric), because of non-numerical comparison.

Re: set analysis expression

jagan — Tue, 23 Dec 2014 09:29:06 GMT

Hi,

Try like this

create a variable

vCurrentQuarter=num(year(today())&'0'&ceil(month(Today())/3))

=Sum({<BU_Year_Quarte{">=$(=vCurrentQuarter)"}>}BudgetCurrentBook)

if you have datefield in your data model then you can use

=Sum({<DateField{">=$(=QuarterStart(Today()))"}>}BudgetCurrentBook)

Hope this helps you.

Regards,

Jagan.

Re: set analysis expression

yevgeniy — Tue, 23 Dec 2014 09:59:12 GMT

may be you helped create variable:

year(today())&'0'&ceil(month(Today())/3)

=Sum({<BU_Year_Quarter={'>=$(yourvaryable)'}>}BudgetCurrentBook)