topic Re: Re: Moving text in QlikView

Moving text

Wed, 19 Feb 2014 10:09:15 GMT

hello everybody,

Is it possible to move text in a text box like we see in new channels using qlikview?

can u suggest me alternatives to achieve the same if possible?

Thank you

Regards,

Prajna

Re: Moving text

MK_QSL — Wed, 19 Feb 2014 10:18:14 GMT

Long time ago, I found something from Qlik Community.

Create a Banner or Text variable.. something like below.

vTodayBanner = ='Welcome to QlikView Community'

Now use below expression in Text Box..

=left(vTodayBanner,mod(Round((now()-now(2))*100000),len(vTodayBanner)+1))

Re: Moving text

vikasmahajan — Wed, 19 Feb 2014 10:22:26 GMT

Here is example

Vikas

Re: Moving text

Wed, 19 Feb 2014 10:30:53 GMT

Thank you..

Regards,

Prajna

Re: Moving text

Wed, 19 Feb 2014 10:31:34 GMT

The above Expression does not work on Web.

Re: Moving text

MK_QSL — Wed, 19 Feb 2014 10:39:38 GMT

Looks like you have selected CORRECT answer to wrong person...

Re: Moving text

Wed, 19 Feb 2014 10:44:46 GMT

your solution served my purpose... but I didn't see how it works after deployment..

Regards,

Prajna

Re: Moving text

Wed, 19 Feb 2014 10:45:48 GMT

Hi,

em new in using extension. can u guide me?

I have turned on web view..but em not able to see extension objects??

Regards,

Prajna

Re: Re: Moving text

MK_QSL — Wed, 19 Feb 2014 10:57:10 GMT

Please find enclosed file and select helpful or correct answer to those who have helped you rather than selecting your own comment.

This will help community members to get more points and encourage to answer.

Thanks for your understanding.

Re: Moving text

sudeepkm — Wed, 19 Feb 2014 11:05:42 GMT

The extension object provided by Vikas is great. It simply renders the HTML <Marquee> text and it works in AJAX mode.

If you are looking for how to use it.

1. Then just double click on the MinimalisticHtmlTextBox.qar file. Then you will see a message box in QlikView like below.

2. Then enable web view in your QVW and

3. add sheet objects and then from the extension object panel you can drag and drop this extension object to your sheet.

4. Then you can right click and go to properties of the extension object and add text like below.

<Marquee>Hello World</Marquee>

Vikas has also added one example. That should work as soon as the extension object is installed.

Re: Moving text

vikasmahajan — Wed, 19 Feb 2014 11:07:12 GMT

To install Extension just copy it in one folder in server , Double click on extension automatically extension will install

and in server you need to select File -> New QVW -> Click on Web View Button ->

Right Click Mouse -> + New Sheet Objects -> Select Extensions -> You will find list of extension over there

This way extensions can be installed.

Vikas

Re: Moving text

Wed, 19 Feb 2014 11:10:42 GMT

yeah I followed same procedure infact I got the similar .qvw document and I tried but em not able to see extension object..may be this would clear what em saying

Re: Moving text

Fri, 20 Feb 2015 05:26:55 GMT

Hi Manish,

whenever user accessing the Dashboard from Web Browser Moving Text is working or not.Based on the below logic.

vTodayBanner = ='Welcome to QlikView Community'

Now use below expression in Text Box..

=left(vTodayBanner,mod(Round((now()-now(2))*100000),len(vTodayBanner)+1))

Re: Moving text

Anonymous — Thu, 10 May 2018 09:35:40 GMT

Hi,

I did it as below:

I have three expressions with text. chr(13) is used just to give space between the expressions.

Left('Total Ticket -'& TodaysTotalTKT & chr (13) &' Pending Ticket -' & TodaysPendingTKT & chr (13)&' Solved Ticket - ' & TodaysSolvedTKT,mod(round((now()-now(3))*100000),len(1000000000000000000000000000000000000000000000000000000000000000)))

Re: Moving text

Anil_Babu_Samineni — Thu, 10 May 2018 09:47:42 GMT

This is old thread, you should open new thread. Anyway The field which you provide will return multi rows which Qlik doesn't know which value it does? Perhaps this

Left('Total Ticket -'& Concat(TodaysTotalTKT, ' ') & chr (13) &' Pending Ticket -' & Concat(TodaysPendingTKT, ' ') & chr (13)&' Solved Ticket - ' & Concat(TodaysSolvedTKT, ' '),mod(round((now()-now(3))*100000),len(1e20)))

Re: Moving text

Anonymous — Thu, 10 May 2018 10:05:23 GMT

len(1e20) doesn't work for my expression.

Thanks in advance

Re: Moving text

Anil_Babu_Samineni — Thu, 10 May 2018 10:15:20 GMT

Should work, May be limitation problem till 1e18? can you try that using len(1e10)

If not working, Forgive me and use this?