Calendar,Financial Year display in the dashboard

[#1]

Dear QV Experts,

I created a text object on hovering can view three options,

1. Financial Year

2. Calendar Year

3. Rolling 12 months

If Financial Year Selected, Then the list box displays, 2013-14, 2014-15, 2015-16

If Calendar Year Selected, Then the list box displays, 2013,2014,2015

If Rolling 12 Months Selected, If we are in Dec15 then Jan15 - Dec15.

                                             If we are in Nov15 then Dec14 - Nov15 to be displayed

I am facing two issues in the dashboard.

1). Hovering on the Calendar Toggle Text Object, If selected Financial Year List Box Displays and respectively for other options

     But data is not refreshing unless if i go & select other values in the List box.

    Can you please suggest me on this

2). For Rolling 12 Months, How to achieve this solution?

Thanks in Advance.

Sasi

[Chanty4u]

dear sasi,

https://community.qlik.com/docs/DOC-9162

hope this helps for rolling...

and use bookmark for selection or,

in listbox properties check always one selected value..

hope dis helps u

Thanks

Suresh

[sunny_talwar]

Data is not refreshing? What does that mean?

[#4]

In the Image below, The CalendarYear Selected. The Year ListBox Shows 2012,2013,2014,2015. Default is 2014.

Here in Number of Incidents KPI displays 166.

In the Image Below, The Financial Year Selected. The listbox shows 2013-14,2014-15,2015-16.

Default is 2014-15.

Here in Number of Incidents KPI still displays 166 only. If i change to some other year & come back it is displaying correctly.

!

Can you please suggest me on this.

Thanks

Sasi

[#5]

If I undertand correctly, you are selecting different options in the Calendar toggle but the KPI values are not changing

I do not see any code in your expression to take into account the year you are selecting from the toggle, so the expression results will alwyas be the same

for RIDDOR, your expression is

=Count({<[Incident RIDDOR Regulations Apply] = {'-1'}>} [Incident Cause Id])/(Sum(EmployeeCount)/12)*1000

but I do not see where you are taking into account a daterange based on the value selected in the calendar toggle

I believe that would be the case for all of your metrics

[settu_periasamy]

Hi Sasi,

Check Your Text Box Actions. In the "Select in Field", "InciYear" you already set the value "2015". That's why It is displaying the same value. Create the "Current Selection" Box, You will see the difference.

I think, If you remove the Year Field, you will get your expected value.

[#7]

THanks Settu. But how to clear field. I am trying many ways & no luck.

Can anyone please suggest me.

[#8]

when you pick a year or range of years from the list box (fiscal or financila year) your objects update - when you go to the calendar toggle, there are not any new dates selected to update the data (the selected dates that are made are not chnaged). Possibly set analysis to to look at data within the range of values based on calendr toggle

if you add a current selects box make some year selections and then change the values in the calendar toggle, you will see what I am trying to explain

[#9 · Accepted solution]

Dear QV Experts,

The tasks which discussed was completed. Enclosed the updated dashboard.

Thanks for your help.

Sasi