Defaulting to Current Month with option to Change Month

[Anonymous]

Qlik World,

I have an expression for a simple bar chart: sum({<LastMonth={1}, BUDGET_ACTUALS={'BUDGET'}>} HEADCOUNT)

This displays the budget of the previous month's headcount, but I am wanting to have it be where the deafult remains the same and allows for past months to also display.

Two part question:

1. How can I edit this expression to allow for this? I already have a month list box on the app, so that part is already done for once I can select a past month.
2. Is there a way to make the title of the object dynamic? It is currently erroneously called Current Month Headcount since it defaults to that view, but once I select a past month, I would like for the title to dynamically become Monthly Headcount.

Regards and many thanks,

JB

[Anil_Babu_Samineni · Accepted solution]

Perhaps this using Title as measure

='You selected' & Concat(Chr(39) & Month & Chr(39), ',') & 'and the count is' & Count(Month)

[Anonymous]

I'll give that a try and get back to you real soon, Anil. Thanks!

[Anonymous]

Anil, that worked for the dynamic title component, very much appreciated. Any advice on the other part regarding having the current month display as the default view with the option to change it with the month selection?

[Anil_Babu_Samineni]

Perhaps this?

=If(GetFieldSelections(Month)>0, 'Current Month headcount', 'You selected' & Concat(Chr(39) & Month & Chr(39), ',') & 'and the count is' & Count(Month))

[Anonymous]

That hasn't worked yet, but I am trying to replace a few terms at the moment and will let you know how it goes. Thanks!

[Anil_Babu_Samineni]

If above one replicate your issue, I think the one which latest should work. May be inter place from last to first like

=If(GetFieldSelections(Month)>0, 'You selected' & Concat(Chr(39) & Month & Chr(39), ',') & 'and the count is' & Count(Month), 'Current Month headcount')

Or

=If(GetFieldSelections(Month)>0, 'You selected' & Concat(Chr(39) & Month & Chr(39), ',') & 'and the count is' & Count(Month), Your Default Measure)

[Anonymous]

This ended up working for me:

if(isnull(GetCurrentSelections()),sum({<CurentMonth={1}, BUDGET_ACTUALS={'BUDGET'}>} HEADCOUNT), sum({<BUDGET_ACTUALS={'BUDGET'}>} HEADCOUNT))

[Anonymous]

There is a similar table with the same filter issue. We have been able to apply some of the solutions that have been suggested here to this table, but we have some issues.

We would like to display Overhead Details with the below columns shown here with no filters applied:

However, we need to be able to filter by month or quarter. As some of the columns are month-specific, we are not sure how to modify the table to display relevant data.

Notice that the current month actual below is the same as the current quarter actual when we have selected to filter by a fiscal month. The current quarter actual needs to include January-March, not only January as it shows now. Currently, if a quarter were selected, then the actuals and the budget display fine.

Here is our current expression for the current quarter budget:

[Anonymous]

Here is the expression for column "Cur Qtr Act":

if(isnull(GetCurrentSelections()), sum({<CurrentQuarter={1}, BUDGET_ACTUALS={'BUDGET'}>}DOLLARS)/1000, sum({<BUDGET_ACTUALS={'BUDGET'}>}DOLLARS)/1000)

It currently returns the same data as "Cur Mon Act" but it should be returning the cumulative actuals for all three months in a given

quarter.

Here is how we define Current Quarter in the data model:

if(ceil([Fiscal Month Number]/3)= ceil(Month(today())/3), 1, 0) as CurrentQuarter,

Thoughts?