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 $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Multiple kpi selection and labeling for Master Items

Hi,

i have one Metric Field in QlikSense based on that Metric field users can select multiple Metrics and they can see those metrics results in my piviot table as below.

now i have created two Measures in Master Items , those 2 master items is nothing but my numerator and denominator for that piviot table results. based on conditional expression it will show those num Value and den value.  now i got a request that instead of showing LES Metric Num and LES Metric Den for all metrics. so respective label name for each Metric.

so example:

raw.PNG

so i wrote as below in Master Item Measure Label Expression and it is not working as expected when user select multiple metrics but single metric it works

For LES Metric Num

If(  [%LMetric]='Timely Project Assignment' ,'Assigned Projects <6 day'  ,

If(  [%LMetric]='Issue Compliance - LES' ,'Projects completed <30 days' ,

 

))

 

For LES Metric Den

If(  [%LMetric]='Timely Project Assignment' ,'Total Projects Completed' ,

If(  [%LMetric]='Issue Compliance - LES' ,'Total Projects Created' ,

 

))

 

0 Replies