topic Re: Display a Text Opposite to Sheet Name in App Development

Display a Text Opposite to Sheet Name

muhammedraleen — Mon, 15 Aug 2022 05:13:52 GMT

Hi All,

I need a way to display a text, exactly opposite to where the sheet name appears in Qlik sense.

Please help me out if there's a way to do it..?

Thanks,

Re: Display a Text Opposite to Sheet Name

saso70 — Mon, 15 Aug 2022 07:21:07 GMT

You can do it with css. Please add multi KPI object on the sheet add in measure value = ' ' and in appearance select style add following css code

#sheet-title .sheet-title-text{position: absolute; top: 0; right: 0; width: 200px; text-align:right;}

Re: Display a Text Opposite to Sheet Name

muhammedraleen — Mon, 15 Aug 2022 07:46:19 GMT

Hi @saso70 ,

Thank you very much for your help. But I need sheet name in left and additional text in right.

Can you please help me on it..?

Re: Display a Text Opposite to Sheet Name

saso70 — Mon, 15 Aug 2022 07:58:23 GMT

Please use REPEAT function in Title expression like this:

='My new sheet'&REPEAT(CHR(160),150)&'YourText'

Re: Display a Text Opposite to Sheet Name

muhammedraleen — Mon, 15 Aug 2022 08:09:34 GMT

Hi @saso70 ,

Thank you very much for your great help...

Can you please help me on how to bold and add color to the 'YourText' part only...

Re: Display a Text Opposite to Sheet Name

saso70 — Mon, 15 Aug 2022 08:32:00 GMT

Hi than you can do that with css only and the expression have to be change in title expression. Please remove 'YOUR TEXT' from expression and add 'YourText' in content section in css:

='My new sheet'&REPEAT(CHR(160),190)&''

Please add multi KPI object on the sheet add in measure value = ' ' and in appearance select style add following css code:

#sheet-title .sheet-title-text::after {
content: "YourText";
color:red;
font-weight: 900!important;
}

Re: Display a Text Opposite to Sheet Name

muhammedraleen — Mon, 15 Aug 2022 11:08:46 GMT

This is what I exactly needed... Thank you very much for your support and time.

Sure I'll Keep you in touch for my learnings