topic Re: Chart title disappers when filters applied in QlikView

Chart title disappers when filters applied

infock12 — Tue, 07 Jul 2015 10:06:08 GMT

Hi all,

Good morning. A very simple question, may be I am doing something elementary wrong.

I have a container within which there are two bar charts. When I apply filters, the chart heading in the second chart disappears. This happens only for the second chart and only where there is no data. Screen shot attached. The top charts without filters applied and the bottom with the filters.

The "Show Title in Chart" box is checked under Properties>General.

Thanks,

Karthik

Re: Chart title disappers when filters applied

Tue, 07 Jul 2015 10:18:22 GMT

When there is no data, the chart title will not be availble.

Re: Chart title disappers when filters applied

infock12 — Tue, 07 Jul 2015 10:23:01 GMT

Thanks Sindhu! Is there no way of keeping the alignment of the cyclic group icon as it is?

Because, the cyclic group icon moves to the top in the second chart when the applied filters have no data but stays the same in the first chart, which kind of looks awkward!

Re: Chart title disappers when filters applied

Tue, 07 Jul 2015 10:34:11 GMT

as I know, there is no way. But you can hide the chart based on the chart expression.

Re: Chart title disappers when filters applied

Siva_Sankar — Wed, 08 Jul 2015 02:55:01 GMT

Karthik,

You can handle by throwing an error message when the chart don't have data when you apply filter. The chart title will remain as it is irrespective of data presence. Find the settings in the below screenshot and look at the attached example.

Re: Chart title disappers when filters applied

infock12 — Wed, 08 Jul 2015 08:59:13 GMT

Thanks Shankar.

I tried it but it didn't work unfortunately. My Expressions section has the following formula.

Expression:

=Num(count({<Response={'No'}>} Questions)/Count({<Response={'Yes', 'No'}>} Questions), '0.00%')

Calculated Condition: =IF(count({<Response={'No'}>} Questions)/Count({<Response={'Yes', 'No'}>} Questions)=0,0,1)

Window Title and Chart Title = IF(count({<Response={'No'}>} Questions)/Count({<Response={'Yes', 'No'}>} Questions)=0, 'No Data To Display', ' Questions Answered "No" - (%)')

Error Message: =IF(count({<Response={'No'}>} Questions)/Count({<Response={'Yes', 'No'}>} Questions)=0, 'No Data')

The Error Message is working, so the formula seems to be right. The same formula appears in both Window Title and Chart Title but they disappear when there is no data. Not sure what is wrong.

Re: Chart title disappers when filters applied

Siva_Sankar — Wed, 08 Jul 2015 09:21:06 GMT

can you share your application?

Re: Chart title disappers when filters applied

avinashelite — Wed, 08 Jul 2015 09:23:44 GMT

please share your app

Re: Chart title disappers when filters applied

infock12 — Wed, 08 Jul 2015 09:32:24 GMT

Hi Shakar and Avinash,

Sorry, it is the personal edition. Do you think it will still work?

Thanks,

Karthik

Re: Chart title disappers when filters applied

Siva_Sankar — Wed, 08 Jul 2015 09:33:29 GMT

Yes, you can still upload.

Re: Chart title disappers when filters applied

infock12 — Wed, 08 Jul 2015 14:12:05 GMT

Here is the file attached. The expressions are written in the second chart.