Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.