topic Re: data formating in QlikView

data formating

NavinReddy — Sat, 16 Nov 2024 00:51:37 GMT

Hello All,

Could someone help me, how could i format the excel data like below image format. kindly help me i would like to format attached excel data below image format.

Regards,

Navin

Re: data formating

NavinReddy — Sat, 11 Apr 2020 17:17:44 GMT

kindly help me with the suggestions

Re: data formating

Frank_Hartmann — Sat, 11 Apr 2020 19:05:56 GMT

see attached.

hope this helps

Re: data formating

NavinReddy — Sat, 11 Apr 2020 21:34:08 GMT

Thanks a lot for your help.

Re: data formating

NavinReddy — Sat, 11 Apr 2020 21:35:35 GMT

Thanks a lot for your help

Re: data formating

NavinReddy — Sat, 11 Apr 2020 21:52:41 GMT

@Frank_Hartmann

sorry if i want to implement same logic with dynamic data, how could i implement, my data will changes based on selection, kindly help me.

Re: data formating

Frank_Hartmann — Wed, 15 Apr 2020 09:32:35 GMT

can u share a sample qvw and a description of the expected behaviour?

Re: data formating

NavinReddy — Wed, 15 Apr 2020 19:14:46 GMT

@Frank_Hartmann sorry for my later reply,

i have added the sample data, i was not able to implement your logic. kindly help me

Re: data formating

Frank_Hartmann — Thu, 16 Apr 2020 09:24:16 GMT

How do you determine which header to use for the ID´s? is there any logic how you assign the IDs to the headers. How many Headers do you need?

Re: data formating

NavinReddy — Thu, 16 Apr 2020 11:27:40 GMT

i want to disply all the list of IDs belongs to the header, we already have mapping. i would like to disply based on header assinged ids. Header under list of IDs.

Re: data formating

NavinReddy — Fri, 17 Apr 2020 05:51:48 GMT

@Frank_Hartmann kidnly help me

Re: data formating

Frank_Hartmann — Fri, 17 Apr 2020 07:35:42 GMT

for me its still not clear which field you want to use as header.

can u share a screenshot (maybe excel) with expected result (just for the first lines/IDs..) based on the QV table you provided?

Re: data formating

NavinReddy — Fri, 15 May 2020 07:22:36 GMT

@Frank_Hartmann Good Morning

i would like to display IDs based on Function. Function header and related IDs . sorry for my bad explanation.

Re: data formating

Frank_Hartmann — Sat, 18 Apr 2020 10:19:49 GMT

see attached qvw

hope this helps

Re: data formating

NavinReddy — Sat, 18 Apr 2020 13:55:48 GMT

@Frank_Hartmann wow that was awesome answe,

please suggest me if want to add any other field to the same list how can i add. thanks a lot for your help

Re: data formating

Frank_Hartmann — Sat, 18 Apr 2020 14:21:12 GMT

which further field/s do you need in the table?

the thing is that you need to make the fieldelements invisible depending on if the line element is an header or an id. therefore have a look at the dim expressions (and its background and text color expressions.) For the new field you just need to adapt the background color expression and the text Color expression....

Re: data formating

NavinReddy — Sat, 18 Apr 2020 16:09:28 GMT

Thank you so much for your help.

i got struck with one issue i have created report using report editor, now i can see one field for one page now i have 100 fields its printing 100 pages, pelase help me how could i arragne with fields based on size on pdf page. kindly help me.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Removing-extra-space-between-fields-in-report-editor/m-p/1691965