Implementing the "ALL" Fiters in Xcelsius

[system]

Hi,

I need to implement the Dashboard with colum chart with regions and corresponding measure.

regions can be APAC,LATAM,EMEA

This column chart should get displayed on the filter selection. If I select one region (APAC) one bar should get displayed in the chart.

For e.g bar should get displayed for let say APAC

If I select ALL in the filter then all bar charts should get displayed in the chart

For e.g bar should get displayed for APAC, LATAM, EMEA.

Regards
S.Sathish

I am using Xcelsius 2008.

---

tnvijay (BOB member since 2013-08-08)

[system]

Hi,

Recently i developed similar kind of thing.

This simple just placed “ALL” word in that Column where you put region name.so that you can get ALL word in selection list say B1. Now put Detination in one cell lets say “C1” Cell
and now put If Contion in D2 cell write IF(C1=“ALL”,Vlookup(B2,SourceDateSelection,Column,0),Vlookup(B2,SourceDateSelection,Column,0))

This forumla you need to extend upto no of Regions present in you sheet.

Then Select this result to chart.

Best Regards,
ATM

---

atulm (BOB member since 2012-06-30)

[system]

In your case…If u select one region say APAC only one bar corresponding to it appears…and it goes on like this…

can u please share your spreadsheet data…and a little elaboration on how its done…

It will be great help to me…

Thanx,
joy

---

JOY1991 (BOB member since 2013-05-15)

[system]

If you are using QaaWS or BI Service connectors, then you can follow some of the steps in this thread:

Using Like In QAAWS to get the data

Hi I need to make a query in QAAWS with Like… But I did not find any matching keywork… I have a date column which has 24 rows of data for a day… How can i pass a date and bring all the rows for that data. for example… date like ‘09-NOV-11’ which will return me 24 rows… if i say date = ‘09-NOV-11’ it is coming back with only one row… Thanks… rajx72 (BOB member since 2006-08-02)

---

Cairmor (BOB member since 2008-06-05)

[system]

Hi,

It depends on where your data is coming from. If you are using Query Browser to bring the data into your excel sheet, then you can pass all to a cell in your excel sheet from the drop down selector. The adjacent cell can be configured to display the #Div/0! error. When you pass that as an input value to your prompt in QB, it will bring back data for all regions. Obviously, your prompt has to configured as optional.

Hope that helps.

Amit

---

amitmishra4 (BOB member since 2007-11-05)

[system]

@amitmishra4

If you are using Query Browser to bring the data into your excel sheet, then

Amit

^^ This is not relevant in Xceisius 2008.

---

Cairmor (BOB member since 2008-06-05)

[system]

Hi Atulm,

Thanks for your reply, Kindly help me out in putting your calculations in the attached excel.

Regards
S.Sathiskumar
Data2.zip (5.0 KB)

---

tnvijay (BOB member since 2013-08-08)