Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

Values in chart - not sure how they coming .?

Hi All,

Please kindly assist me , I am not getting how the values in the chart are showing.

when =[$(vDisplayedBy)] is "ESRG Description" but not clear how the "631 Tracheostomy or ventilation >95 hours" are coming from

5.PNG

In the below image ,

3.PNG

 

In dimension field a variable is used =[$(vDisplayedBy)] with the values defined in script  

set vDisplayedBy=Episode Clinician Name on Separation,Episode Specialty on Separation,Facility Name,SRG Description,ESRG Description,DRG Description,Primary Diagnosis Description,Primary Procedure Description,Planned Separation'

 

and in expression :

Pick(Match(vLOSDisplay, 'Median', 'Average'),
Median([Measure_LOS]),
Avg([Measure_LOS])

)

 

4.PNG

Labels (1)
1 Reply
mfchmielowski
Creator II
Creator II

Hi,

Have you checked your source table for values in column 'ESRG Description' ?
Are the symptoms exacly the same when you put this column as a dimension by exact column name (not by variable) ?