topic How to write set analysis for dates in QlikView

How to write set analysis for dates

rahulhv1 — Mon, 11 Aug 2014 11:33:43 GMT

I want below to work.

=SUM({< [FinanceRelease] = {$(=(CalendarDate))} >} [Capex Item Gross Value])

where selected CalenderDate is 31-07-2014 (All the date formats are same i.e. DD-MM-YYYY) then also this is not working

where as

when i write

=SUM({< [FinanceRelease] = {'31-07-2014'} >} [Capex Item Gross Value])

it works perfectly ok.

Re: How to write set analysis for dates

avinashelite — Mon, 11 Aug 2014 11:36:47 GMT

Try like this

SUM({< [FinanceRelease] = {'$(=CalendarDate)'} >} [Capex Item Gross Value])

Re: How to write set analysis for dates

manideep78 — Mon, 11 Aug 2014 11:37:57 GMT

HI Rahul, try like this

=Sum({<[FinanceRelease]={'$(CalendarDate)'}>}[Capex Item Gross Value])

=Sum({<[FinanceRelease]={"$(CalendarDate)"}>}[Capex Item Gross Value])

It should work.

Regards,

Manideep

Re: How to write set analysis for dates

rahulhv1 — Mon, 11 Aug 2014 11:38:48 GMT

Nope its not working Avinash

Re: How to write set analysis for dates

PrashantSangle — Mon, 11 Aug 2014 11:40:23 GMT

Hi,

Kindly check the following steps,

1: check that what it returns when you type in $(=(CalendarDate)) in text Object

2: use similar expression which you are trying in expression variable in your set analysis

3: Also check that after your expression execution your variable is still giving you out put in date format or number format.

Regards

Re: How to write set analysis for dates

rahulhv1 — Mon, 11 Aug 2014 11:47:00 GMT

=Sum({<[FinanceRelease]={"$(CalendarDate)"}>}[Capex Item Gross Value])

This is working i.e. WHEN I USED Double Quote , it worked perfectly ok. But now the problem is other

i want to you <= i.e. date < or = ,

=Sum({<[FinanceRelease]={"$(<= CalendarDate)"}>}[Capex Item Gross Value])

is not working.

Re: How to write set analysis for dates

manideep78 — Mon, 11 Aug 2014 11:55:24 GMT

Like this:

=Sum({<[FinanceRelease]={<="$(CalendarDate)"}>}[Capex Item Gross Value])

Regards,

Manideep

Re: How to write set analysis for dates

rahulhv1 — Mon, 11 Aug 2014 12:04:56 GMT

Nope, I already tried that,

=Sum({<[FinanceRelease]={"$(= max(CalendarDate))"}>}[Capex Item Gross Value])

this works but when i put < it dos't work enven if i write as per your above statement, it do not work. It give syntax error (Red line)

Re: How to write set analysis for dates

manideep78 — Mon, 11 Aug 2014 12:14:08 GMT

Hi Rahul

Try this: (Include <= symbol in double quotes before $ symbol)

=Sum({<[FinanceRelease]={"<=$(CalendarDate)"}>}[Capex Item Gross Value])

This will work for sure.

Regards,

Manideep

Re: How to write set analysis for dates

rahulhv1 — Tue, 12 Aug 2014 03:51:31 GMT

no.. its not working