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

Adding text as pop-up causes "No data to display"

Hey there,

A bit of a weird problem.  I have a bar chart showing lowest 10 values of a field and when I add a second expression as "Text as Pop-up" it causes the chart to error out and display "No data to display".

='Primary DRG: ' & [Primary DRG]

& chr(13) &

'Average weight: ' & AVG({<[Roll Up Class] = {"Inpatient"}, [Primary DRG Code] = {"<> 795"},[Discharge Date ID]= P({1<[Month Start]={">=$(=num(addmonths(Today(),-13))) <=$(=num(addmonths(Today(),-1)))"}>}[Reference Date ID])>} num([Billing CMI Weight]))

However, when I remove [Primary DRG], it causes the data to display again.  What is it about this field causing my chart to error out?  Does anyone have any ideas?

2 Replies
trdandamudi
Master II
Master II

Is it possible to attach a small sample file ? Check if [Primary DRG] is in your data model, it is case sensitive and make sure you have exactly the way it is defined in the model.

shinnickr
Creator II
Creator II
Author

Unfortunately I can't because it contains sensitive information and I don't necessarily trust the scramble function in Qlik.  I will try to recreate it, but I don't know if I can.