Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
chrisbrown1
Contributor III
Contributor III

Dimensions as Measures for KPIs

I am trying to use Dimensions as Measures for KPI's (It is just strings). That way I can customize the CSS for the measures. I have a sheet that looks like the following:KPIs.PNG

 When a Program is selected the KPIs look like the following:

KPIs1.PNG

The issue that I have is when the Title is not specified the KPI returns NULL as expected. But I would like to output an empty string or surpress/hide the KPI for that dimension.

The dimension is: SA_ID

The measures that I am using for the KPI's are of the form:

ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST)

ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST)

ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST)

How else can I aggr the data to produce an empty string when there is not a value for that Title?

The KPIs.qvf is attached.

 

Labels (3)
1 Solution

Accepted Solutions
rachel_delany
Creator II
Creator II

Try:

IF(ISNULL(ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST),'',ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST))

IF(ISNULL(ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST),'',ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST))

IF(ISNULL(ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST),'',ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST))

View solution in original post

2 Replies
rachel_delany
Creator II
Creator II

Try:

IF(ISNULL(ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST),'',ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST))

IF(ISNULL(ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST),'',ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST))

IF(ISNULL(ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST),'',ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST))

chrisbrown1
Contributor III
Contributor III
Author

Thank you Rachel,

There was a missing parentheses in your solution, Thanks for your help.

IF(ISNULL(ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST))
,'',ONLY({$<TITLE={'SDO'}>} 'SDO: ' & NAME_FIRST & ' ' & NAME_LAST))

IF(ISNULL(ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST))
,'',ONLY({$<TITLE={'PCO'}>} 'PCO: ' & NAME_FIRST & ' ' & NAME_LAST))

IF(ISNULL(ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST))
,'',ONLY({$<TITLE={'Record Admin'}>} 'Record Admin: ' & NAME_FIRST & ' ' & NAME_LAST))