topic Re: Different Static Text in different sheets in QlikView

Different Static Text in different sheets

Anonymous — Thu, 27 Aug 2015 17:50:33 GMT

Hello All,

I have a common Load script. I have created different sheets(Sheet1,Sheet2,Sheet3) based on product types. Now i want to display static text which is different from each sheet.

Following is the Static Text Table i want to dislay in Sheet 1. Similarly i have different static text tables for Sheet2,Sheet3.....

This static Text differs from every sheet.

Can you please help.

Regards,

Paul

Re: Different Static Text in different sheets

Qrishna — Thu, 27 Aug 2015 18:04:41 GMT

what do you exactly mean by static text in each sheet.

post an app with some dummy data and demonstrate your problem in that.

Thanks

Re: Different Static Text in different sheets

swuehl — Thu, 27 Aug 2015 18:06:52 GMT

Maybe just use an image of your static text? For example as background in a text box.

Re: Different Static Text in different sheets

ziadm — Thu, 27 Aug 2015 18:09:08 GMT

Let me rephrase you inquiry

is it what you are looking for by clicking on the product type should take you directly to the related sheet ?

Re: Different Static Text in different sheets

Anonymous — Thu, 27 Aug 2015 18:09:52 GMT

Krishna,

I have 7 Sheets and I have to create 1 table(Similar to above data image show in my question) in each sheet .

The each table will contain different data.

Regards,

Paul

Re: Different Static Text in different sheets

chaper — Thu, 27 Aug 2015 18:13:21 GMT

Each sheet is different in data based on CounterParty Type??Looks like you need a pivot table in each sheet

Re: Different Static Text in different sheets

Anonymous — Thu, 27 Aug 2015 18:17:07 GMT

Thank you All.

Swuehi: How do i add an object having Image. I think this will be a good thought.

Once again thanks.

Regards,

Paul

Re: Different Static Text in different sheets

chaper — Thu, 27 Aug 2015 18:19:42 GMT

Create text object and in background choose image and change it to your required static text Image

Re: Different Static Text in different sheets

Anonymous — Thu, 27 Aug 2015 18:26:47 GMT

Super. Thank you all.

Chaiperi: i was able to create using the text.

regards,

Paul

Re: Different Static Text in different sheets

Qrishna — Thu, 27 Aug 2015 18:27:13 GMT

oh so you mean if a user clicks on your chart it should be unaffected?

Re: Different Static Text in different sheets

Anonymous — Thu, 27 Aug 2015 18:33:37 GMT

Yes Krishna . I want the table to be shown as Image so that users can see how much % is being assigned.

Thank you all for all the help.

Re: Different Static Text in different sheets

Qrishna — Thu, 27 Aug 2015 18:37:34 GMT

then you cannot use an image in a chart as you've said the data/text changes in each sheet.

you can use 'read only' option in the chart general properties.

if you do so, user can see the chart as static text chart.

they cannot select anything on the chart.

See attached.

thanks

Re: Different Static Text in different sheets

Anonymous — Thu, 27 Aug 2015 18:42:49 GMT

I wanted to show the diff table(as given in my question) in each sheet. i think showing image using text also satisfies my requirement.

Regards,

Paul