topic Re: Text boxes overlapping inspite of conditional formatting in QlikView

Text boxes overlapping inspite of conditional formatting

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a query with regards to conditional formatting. Currently we have hosted a dashboard on a UAT environment. We have used conditional formatting for all of the text boxes being used on the dashboard, however on the access point, inspite of the conditional formatting being in place, the text boxes persist to overlap. Can't figure out the reason for the same.

Could someone please assist?

Providing a screenshot below

Re: Text boxes overlapping inspite of conditional formatting

vishsaggi — Tue, 20 Jun 2017 12:04:46 GMT

Did you try moving the text objects to different positions. Like in text object properties -> Caption tab -> Positions

Like below: try change the X pos and Y pos on each text objects and see? If this is not what you are looking for can you elaborate with an example file please?

Re: Text boxes overlapping inspite of conditional formatting

felipedl — Tue, 20 Jun 2017 12:15:59 GMT

Hi Joshua,

What would you be testing in the conditional formatting your using?

I would guess it's something with the formula your using, can you share more info?

Felipe.

Re: Text boxes overlapping inspite of conditional formatting

vikasmahajan — Tue, 20 Jun 2017 12:20:41 GMT

Click + Shift + Alt and drag and check this test condition

Vikas

Re: Text boxes overlapping inspite of conditional formatting

DavidFoster1 — Tue, 20 Jun 2017 12:51:57 GMT

This could be because you have 'force show' setting on. Try Ctrl+Shift+S which is used to toggle 'force show'

Re: Text boxes overlapping inspite of conditional formatting

Anonymous — Thu, 22 Jun 2017 13:10:42 GMT

Hi David, where can I find this force show option in Qlikview?

Re: Text boxes overlapping inspite of conditional formatting

Anonymous — Tue, 27 Jun 2017 09:24:28 GMT

Hi All, where can I/how can I get a hold of the Force Show option?

Re: Text boxes overlapping inspite of conditional formatting

avinashelite — Tue, 27 Jun 2017 09:26:40 GMT

Go to Setting >Document Properties > Security > and Show All sheets and objects - Un-check this option

Re: Text boxes overlapping inspite of conditional formatting

Anonymous — Tue, 27 Jun 2017 10:16:20 GMT

Hi Avinash, the option was un checked by default. However this issue of overlapping arises only on the UAT server access point and not on the local copy of the dashboard.

Re: Text boxes overlapping inspite of conditional formatting

avinashelite — Tue, 27 Jun 2017 10:31:30 GMT

Strange !!! try to check move your local file to UAT and then check whether the issue occurs again ? I think the QA file options are different than the local one

Re: Text boxes overlapping inspite of conditional formatting

sujeetsingh — Tue, 27 Jun 2017 10:39:19 GMT

There may be the case with transparent background of any one of the textboxes.

Re: Text boxes overlapping inspite of conditional formatting

Anonymous — Fri, 11 Aug 2017 14:59:46 GMT

Check move into what sense exactly?

Re: Text boxes overlapping inspite of conditional formatting

Anonymous — Fri, 11 Aug 2017 15:00:38 GMT

Could you please elaborate on the case of the transparent background? As all of the textboxes that we have used are transparent.