topic Re: Missing data in QlikView

Missing data

Thu, 25 Sep 2014 16:05:44 GMT

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,

Re: Missing data

jyothish8807 — Thu, 25 Sep 2014 16:17:42 GMT

Hi Kris,

Since it is appearing in dimension, i guess there is some issue with your expression.Can to share a sample data you are using?

Regards

Re: Missing data

Thu, 25 Sep 2014 16:27:01 GMT

Add Payor as a dimension in the chart..and see do you have any associative/relevant data for each value of Payor.

Thanks,

Singh

Re: Missing data

Thu, 25 Sep 2014 16:56:27 GMT

I added payor as a dimension and still no data for Medicaid.

Re: Missing data

jyothish8807 — Thu, 25 Sep 2014 17:00:12 GMT

I think Medicaid and Commercial have same value because of which only one value is populating.

Regards

Re: Missing data

Thu, 25 Sep 2014 17:01:57 GMT

Can you try to use Table Box and enter Payor column and field which you are using in expression.

Since you said you can see data in preview, so i doubt the issue is with your expression.

Re: Missing data

Thu, 25 Sep 2014 17:05:30 GMT

Hi Angad,

I created a table box and now can see it but I don't know if this will give us the look we need like the chart.

Do you know why it would do that?

Re: Missing data

Thu, 25 Sep 2014 17:06:53 GMT

Great...so you have valid available for Medicaid....now can you please send the expression, so that we can verify it once?

your expression is skipping the data for Medicaid.

Re: Missing data

Thu, 25 Sep 2014 17:07:00 GMT

We would need the expressions to sum up the "medicaid" numbers and I don't think the table box will do that.

Re: Missing data

Thu, 25 Sep 2014 17:09:01 GMT

Table box was just for testing purpose to check whether we have valid data or not.

We will be using either Straight Table or Pivot table chart to see the final thing.

Use Straight Table

Add Payor as Dimension and Sum(Revenuefield)

and see if you get results

Re: Missing data

Thu, 25 Sep 2014 17:09:36 GMT

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

Re: Missing data

Thu, 25 Sep 2014 17:12:34 GMT

Yep that worked.

Re: Missing data

Thu, 25 Sep 2014 17:13:34 GMT

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

Re: Missing data

Thu, 25 Sep 2014 17:15:38 GMT

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

Hope this was helpful

Re: Missing data

jyothish8807 — Thu, 25 Sep 2014 17:17:33 GMT

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

Re: Missing data

Thu, 25 Sep 2014 17:18:26 GMT

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!!!

Re: Missing data

Thu, 25 Sep 2014 17:21:02 GMT

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.

Re: Missing data

Thu, 25 Sep 2014 17:22:44 GMT

Thank you Angad!

Re: Missing data

Thu, 25 Sep 2014 17:23:09 GMT

Thanks Jyothish!

Re: Missing data

jyothish8807 — Thu, 25 Sep 2014 17:31:20 GMT

You are Welcome