Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

philmywallet
New Contributor III

Refresh Date - Text Box

I have several different data sources all going into one dashboard report.  Each tab has a different theme.....

Employed staff

Starters & Leavers

Additional Hours

Agency working

Sickness Levels

I have created a single table which holds the date and time each data source was last refreshed.  (see below)

Refresh_Date                Area

2015-08-13 14:17:33      Employed Staff Refreshed

2015-08-13 14:35:29      Starters_Leavers Refreshed

2015-08-13 14:41:41      Additional Hours Refreshed

2015-08-13 14:35:30      Agency Refreshed

2015-08-13 14:35:40      Sickness Refreshed

I want to create a text box that only shows the relevant refresh date for each tab.

I have done this before when there was only 1 row in the data (e.g. ='Data last refreshed '&Refresh_Date), however I am unsure how I can get my text box to show the date for each separate row, based on the tab (i.e.  only show refresh date for Sickness on the sickness Tab, only show Employed Staff date on Employed Staff tab, etc)


Any thoughts?



Thanks




Phil

Tags (1)
1 Solution

Accepted Solutions

Re: Refresh Date - Text Box

Try it with Only() function

=Only({<Area = {'Employed Staff Refreshed'}>}Refresh_Date)

4 Replies

Re: Refresh Date - Text Box

=Only(IF(WildMatch(Area,'Additi*'),Refresh_Date))

Re: Refresh Date - Text Box

Try it with Only() function

=Only({<Area = {'Employed Staff Refreshed'}>}Refresh_Date)

sasiparupudi1
Honored Contributor III

Re: Refresh Date - Text Box

if you have sheets

Employed staff(SH01)

Starters & Leavers(SH02)

Additional Hours(SH03)

Agency working(SH04)

Sickness Levels(SH05)

if (SubField(GetActiveSheetId(),'\',2)='SH05',Only({<Area = {'Sickness Refreshed'}>}Refresh_Date))


The code excerpts are taken from Manish and Sunny


hth

Sasi

philmywallet
New Contributor III

Re: Refresh Date - Text Box

worked well.  cheers

Community Browser