topic Re: Unable to Hide 0 Values After Making Selections in QlikView

Unable to Hide 0 Values After Making Selections

makximenkoa — Thu, 30 Nov 2017 16:23:53 GMT

Hello,

After adding a different master calendar to my app, certain charts no longer hide 0 values after making selections. For example, clicking on a Month-Year field filters the data, but keeps showing the Month-Years on the chart that were not selected. The same is also happening on a bar chart summing buckets by denial categories instead of by Month-Year. However on a chart similar to the first, I see everything as expected, that is, if i select September, I only see September.

I have also made sure of the following for these 3 charts:

Dimensions tab -> Suppress When Value Is Null is checked

Presentation tab -> Suppress Zero-Values is checked

Presentation tab -> Suppress Missing is checked

Presentation tab -> Show All Bars is unchecked

A sample app is attached. Clicking the blue Denial Write-off Amounts button will toggle the 'broken' all navy blue chart to the stacked bar chart which is working correctly.

Any help would be greatly appreciated!

Thanks,

Re: Unable to Hide 0 Values After Making Selections

sunny_talwar — Thu, 30 Nov 2017 16:27:36 GMT

Your attached file seem to have section access and we don't have access.... can you remove section access and put it back

Re: Unable to Hide 0 Values After Making Selections

makximenkoa — Thu, 30 Nov 2017 16:31:55 GMT

My apologies, I deleted the section access tab in the script but I guess there's more that needs to be done. Do you know where exactly I need to make those changes before I reupload?

Re: Unable to Hide 0 Values After Making Selections

sunny_talwar — Thu, 30 Nov 2017 16:33:28 GMT

After removing the section, did you reload the app?

Re: Unable to Hide 0 Values After Making Selections

makximenkoa — Thu, 30 Nov 2017 16:42:36 GMT

I did not. I've refreshed and reuploaded the sample app.

Re: Unable to Hide 0 Values After Making Selections

sunny_talwar — Thu, 30 Nov 2017 16:47:23 GMT

Add an if statement to you second expression

=If(MonthYear, 'Tx Post Month Year: ' & MonthYear & chr(13)

& 'Denial Write-offs as a % of Gross Charges: ' & num(Sum([Denial Write-off Amount])*(-1)/Sum({$<[$(=Concat({1<$Field-={'Service Area'}>}distinct $Field,']=,[')&']=')>}[Gross Charges]),'#,##0.00%'))

Re: Unable to Hide 0 Values After Making Selections

makximenkoa — Thu, 30 Nov 2017 17:39:13 GMT

That did the trick! Thanks again!