topic Re: How to correct the display ? in QlikView

How to correct the display ?

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

Hi All ,

The text part of my model is not working correctly when I am selecting from any filter.

See snapshot

But I am selecting any product , the Display breaks

sample attached.

Re: How to correct the display ?

jonathandienst — Wed, 09 Nov 2016 13:14:21 GMT

Use this for the text box expression instead:

= 'Aspen Data Refresh: ' & TimeStamp((vAspenDist),'YYYY-MM-DD hh:mm') & Chr(10) &

'IHS Data Refresh: ' & TimeStamp((vIHS),'YYYY-MM-DD hh:mm') & Chr(10) &

'PIN Data Refresh: ' & TimeStamp((vPIN),'YYYY-MM-DD hh:mm') & Chr(10) &

'NRP Data Refresh: ' & TimeStamp((vNRP),'YYYY-MM-DD hh:mm') & Chr(10) &

'SCS Data Refresh: ' & TimeStamp((vSCS),'YYYY-MM-DD hh:mm') & Chr(10) &

'ULG Data Refresh: ' & TimeStamp((vULG),'YYYY-MM-DD hh:mm') & Chr(10) &

'UPD Data Refresh: ' & TimeStamp((vUPD),'YYYY-MM-DD hh:mm')

Now selections do not mess up the layout.

NOTE that the format letter M (capitals) is the month, and format letter m (lower case) is minutes.

Re: How to correct the display ?

kuczynska — Wed, 09 Nov 2016 13:15:03 GMT

Hi,

Should this text box be responsive to any selections made by you? If not - try using alternate states and set text box in different state than any other object on this tab.

Re: How to correct the display ?

suvechha_b — Wed, 09 Nov 2016 13:22:42 GMT

Hi ,

I am not getting any Alternate State

Re: How to correct the display ?

suvechha_b — Wed, 09 Nov 2016 13:24:42 GMT

Hi Jonathan,

When I use your expression , I am losing the fileDate for other Distributor . Please see the snapshot.

Re: How to correct the display ?

kuczynska — Wed, 09 Nov 2016 13:28:38 GMT

Firstly you have to create your alternate state. Go to Settings > Document Properties > click on Alternate States button and create your new state: