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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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) ?