Expressions for different Bar groups date filter

Anonymous — Mon, 11 Mar 2013 21:21:55 GMT

Hi,

We have a bar chart and these bars are computed dynamically. Like

if some one selects year then these bars are daily,

if 3 years have been selected then each bar should be computed for monthly.

Incase of 5 years each bar should represent quarterly.

Dimensions :

1.Date

2.Month

3.Quarter

4.MonthEndDate

5.QuarterEndDate

Fact:

Accumulated Value

In this case i might not be able to use sum(accumulated assets) because bar groups are different.Monthly and quarterly bars need to display MonthEndDate's Accumulated Value, Quarter Ends Accumulated value respectively.

Here is the code I am using not working correctly:

Dimenions:

=IF(Date>=vStartDate

AND Date<=vEndDate

AND Date-vStartDate<366

, DAY(Date)&'/'&LEFT(MONTH(datec),3)&'/'&RIGHT(calendar_year,2),

IF(datec >=vStartDate

AND datec<=vEndDate

AND vEndDate-vStartDate<1860

AND vEndDate-vStartDate>366

,LEFT(MonthName(month_end_buesiness_date),3)&' '& RIGHT(MonthName(MonthEndDate),2),

IF(datec >=vStartDate

AND datec<=vEndDate

,RIGHT(year(QuarterEndDate),2)&' '&calendar_qtr)))

Fact:

=IF(vEndDate-vStartDate<366

,SUM(Accumulated Value,)

IF(ndDate-vStartDate<1830

AND ndDate-vStartDate>366

,<MonthEndDate's Accumulated Value >,

<QuarterEndDate's Accumulated Value >)

Please let me know any better approach.

Thanks

Dasu.G

Re: Expressions for different Bar groups date filter

Anonymous — Tue, 12 Mar 2013 00:52:18 GMT

Hi ,

Find the attached QVW file. Behavior we are looking for is that when some one clicks on 2 YR then X axis should have monthly bars(working) and expression should be retreived the Accumulated Value for the month end days value only not sum of entire month.

Thanks

Dasu.G

Re: Expressions for different Bar groups date filter

Anonymous — Tue, 12 Mar 2013 15:23:02 GMT

Any thoughts on this?.Can this be achievable to show only month end data in the monthly bar?

topic Re: Expressions for different Bar groups date filter in QlikView

Expressions for different Bar groups date filter

Re: Expressions for different Bar groups date filter

Re: Expressions for different Bar groups date filter