Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Auto switching of comments in a text box

Hi Geniuses,

I have a very strange requirement from client , what they want is that they have a comments field like below

Comments
Thank you Chetan

14th of December 2015 was the day I reported this issue and ETS finally fixed it today on the 28th of January 2016 a month an a half is too long to fix an issue.

Thanks for your support though

Speedy and quick resolution.
Thank you Chetan for your timely assistance. Appreciate it very much.

Now as they want to show these comments on TV so what they want is that in one text box these comments will keep on switching after every 5 seconds. Also please dont think that they have only these 4 comments, they have 1000 of comments and keep on adding and they want to show those comments randomly in one text box.

Thanks,

S

2 Replies
sunny_talwar

Try this:

=Pick(Ceil(Second(Now(1))/5),

Only({<Key = {1}>}  Comments),

Only({<Key = {2}>}  Comments),

Only({<Key = {3}>}  Comments),

Only({<Key = {4}>}  Comments),

Only({<Key = {1}>}  Comments),

Only({<Key = {2}>}  Comments),

Only({<Key = {3}>}  Comments),

Only({<Key = {4}>}  Comments),

Only({<Key = {1}>}  Comments),

Only({<Key = {2}>}  Comments),

Only({<Key = {3}>}  Comments),

Only({<Key = {4}>}  Comments))

MarcoWedel

Hi,

maybe one solution might be:

=FieldValue('Comments',Mod(div(Now(),'00:00:05'),FieldValueCount('Comments'))+1)

QlikCommunity_Thread_239927_Pic1.JPG

hope this helps

regards

Marco