topic Re: Text Object in QlikView

Text Object

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

Hi All,

I have one requirement like .

If you can please look into my attachment . I have a straight table with only one column WHich in real time I will hide it below any other chart . and i want a text object or action button upon single clik it should give me the values on the excel sheet . (Customer ID) .

I have to hide my one column excel sheet , thats the reason I want to have a button to eport to excel.

Thanks in Advance

Re: Text Object

felcar2013 — Thu, 30 Jul 2020 07:30:12 GMT

try this

=concat(CustomerID,'\n')

Re: Text Object

smilingjohn — Thu, 30 Jul 2020 07:48:53 GMT

Thank @felcar2013

This work as i desired . Now how do i export this values to excel sheet ?

Thanks

Re: Text Object

felcar2013 — Thu, 30 Jul 2020 08:02:28 GMT

I think you can do the following:

you can export the text box contente to excel. Click on the text box, then right click, press on "export to excel". In excel you will get the content in only one cell "A1". You can unstack the cell content into many cells (different columns) then you transpose it. Finally you get only one column. Hope it helps

Re: Text Object

smilingjohn — Thu, 30 Jul 2020 08:14:26 GMT

I want to click and it has to print all the values . Is it possible as I have to provide a action button and Need to print one fiel value in an excel .

Tahnks

Re: Text Object

felcar2013 — Thu, 30 Jul 2020 08:22:14 GMT

How exaclty is your requirement? what is the output?

you can create an action button to export the text box content, then in excel use data transformation to get what you need in excel

Re: Text Object

smilingjohn — Thu, 30 Jul 2020 08:36:50 GMT

Hi @felcar2013

I have to hide my one column excel sheet , thats the reason I want to have a button to eport to excel.

Thanks .

Re: Text Object

felcar2013 — Thu, 30 Jul 2020 11:51:49 GMT

see file