Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Wael
Contributor
Contributor

KPI For Dimension

Hello everyone hope anyone can help me 

i have a filter pane with field (CommitteeName)

and i want to create a KPI for field (PeriodNumber) which is a Dimension

so i want when i select the data in the filter pane i want the periodNumber for the committeeName to Appear 

how can i do it ?

 

1 Solution

Accepted Solutions
brunobertels
Master
Master

in a KPI object try with concat 

KPI 

concat(distinct periodNumber ,'-') 

distinct to display unique each distinc value 

'-' : used as separator between period number 

View solution in original post

1 Reply
brunobertels
Master
Master

in a KPI object try with concat 

KPI 

concat(distinct periodNumber ,'-') 

distinct to display unique each distinc value 

'-' : used as separator between period number