Missing data

[#1]

I built a chart in Qlikview but not all the fields are populating data and when I go to the Tables and preview it, it is there.  It is populating the dimension fields, but not the expressions.  But what's really weird is if I select some criteria (payor = commercial) the data will populate but if I select different criteria (payor = Medicaid) it doesn't show.  I couldn't attach both images, but if I select Medicaid the data disappears.  Any ideas.  Thanks,

[#2]

Here is the screen shot of the expression tab - is this what you mean?

[#3]

Yep that worked.

[#4]

you should use SUM function.......and not direct field in expression.

[#5]

great, now use SUM() in your original chart and see if value for that expression comes.

Hope this was helpful

[jyothish8807]

Hi,

In a straight chart write:

sum(NetrevenueAmt)

This will solve the problem.The issue is because you have multiple entries and QV is getting confused.Don't take DRGNM in dimension.Take only payerscategory in dimension.

Regards

KC

[#7]

That works - the only thing is there is a percentage in the data that loads, so I think I'll have to put the calculations in Qlikview, because I can't sum on that.

Thank you so much!!!

[#8 · Accepted solution]

You can use different aggregate functions as well like AVG(), MAX(), MIN(), SUM() in qlikview.

Do not forget to mark any answer which was helpful or even correct.

[#9]

Thank you Angad!

[#10]

Thanks Jyothish!

[jyothish8807]

You are Welcome