Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Here is the screen shot of the expression tab - is this what you mean?
Yep that worked.
you should use SUM function.......and not direct field in expression.
great, now use SUM() in your original chart and see if value for that expression comes.
Hope this was helpful
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
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!!!
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.
Thank you Angad!
Thanks Jyothish!
You are Welcome