topic Re: report format: reflect the table fields as a header in QlikView

report format: reflect the table fields as a header

Wed, 25 Nov 2020 16:16:04 GMT

My data looks like this :

type	year	quarter	week	count
assessment	2016	Q1	57	500
bridging	2016	q2	58	6000

I need it to look like this instead

name	2016	jan	quarter	week 57
bridging	5000	5	60	1
assessment	15000	15	800	15

Any guidance will be deeply appreciated please

Re: report format: reflect the table fields as a header

Gysbert_Wassenaar — Fri, 02 Dec 2016 11:58:31 GMT

Well, you'll have to explain first how 6000 turns into 15000 and 15 and 800 and 15 and where the field jan comes from.

Re: report format: reflect the table fields as a header

sunny_talwar — Fri, 02 Dec 2016 11:59:43 GMT

How is your raw data? Would you be able to share a sample here?

Re: report format: reflect the table fields as a header

Fri, 02 Dec 2016 12:15:15 GMT

Hi.

Ultimately I need to take the data and instead of displaying horizontal I need to make it display vertically and allow for the headers to then have a drop box..

I am really bad at trying to explain this... but I will try

Re: report format: reflect the table fields as a header

Fri, 02 Dec 2016 12:19:36 GMT

How Do I attach files here?

Re: report format: reflect the table fields as a header

Fri, 02 Dec 2016 12:24:21 GMT

So I have the following fields:

Year

Month

Quarter

week of year

each dimension with an expression : showing me total clients per year, month, quarter, week of year this is

done vertically , I need to change to format to represent it in a horizontal format.

Re: report format: reflect the table fields as a header

sunny_talwar — Fri, 02 Dec 2016 15:59:52 GMT

Look here:

Uploading a Sample

Re: report format: reflect the table fields as a header

Mon, 05 Dec 2016 05:48:06 GMT

Morning

I have attached the sample data , thank you

Re: report format: reflect the table fields as a header

ganeshsvm — Mon, 05 Dec 2016 11:30:03 GMT

Do you need something like this?

Re: report format: reflect the table fields as a header

Mon, 05 Dec 2016 11:47:45 GMT

I require it to look like this:

Br Intervention	2016	Dec	Week : 48
Bridged	15	4	1
Other forms	10	0	0

So where the year column is, it would reflect the actual current year we are in with the drop down list

month would reflect the current month we are in as well as the drop down list to change to a different month

week to would reflect the current week we are in as well as the drop down list to change to other weeks

The counts would then reflect the under the appropriate year , month and week respectively.

Re: report format: reflect the table fields as a header

sunny_talwar — Mon, 05 Dec 2016 12:14:48 GMT

Please share the logic behind the output you are expecting to see

Re: report format: reflect the table fields as a header

ganeshsvm — Tue, 06 Dec 2016 06:55:30 GMT

Is it mandatory to display the result in table(Straight/Pivot) chart or any other combination of Objects is also OK?