topic Re: Crosstable formatting in QlikView

Crosstable formatting

marakud971 — Sat, 16 Nov 2024 02:48:33 GMT

Hi everyone,

I would like to know if it's possible to have this exact crosstable formating in qlikview ? (see the picture).

The number 1, in the picture is the month's number.

Thanks a lot.

Re: Crosstable formatting

Frank_Hartmann — Tue, 06 Aug 2019 17:45:44 GMT

see attached qvw file.

hope this helps

Re: Crosstable formatting

marakud971 — Tue, 06 Aug 2019 19:10:44 GMT

Hi,

thanks for your answer.

How could i have your result if QTE and QTE en hl is two distinct colunms ?

In your example, they are in the same.

Re: Crosstable formatting

Frank_Hartmann — Tue, 06 Aug 2019 19:43:12 GMT

see attached

hope this helps

Re: Crosstable formatting

marakud971 — Tue, 06 Aug 2019 20:17:19 GMT

thanks,

but it seems like this is the same file you already send.

QTE and QTE en hl are in the same col.

Re: Crosstable formatting

Frank_Hartmann — Tue, 06 Aug 2019 20:21:08 GMT

No, have a deeper look at expression tab. there are two expressions now.

one for QTE and the other for QTE en hl

Re: Crosstable formatting

marakud971 — Tue, 06 Aug 2019 20:26:35 GMT

okey !!!! yes !!!

so, even if in my database , i've two colunm for each value,

i can use these expressions ?

Re: Crosstable formatting

Frank_Hartmann — Tue, 06 Aug 2019 20:42:30 GMT

OK. I understand.

See attached

Re: Crosstable formatting

marakud971 — Wed, 07 Aug 2019 05:31:52 GMT

The file is interesting, but the formulas are complicated for me.
I tried to adapt them to my reports but I can not do it. Can you help me adapt it so that I can master your method? I have attached my report.

Re: Crosstable formatting

Frank_Hartmann — Wed, 07 Aug 2019 08:42:33 GMT

i am really not sure if this is what you need.

if not, please give more information how output should look like...

Re: Crosstable formatting

marakud971 — Mon, 12 Aug 2019 18:43:08 GMT

Hello, it is for me a very good beginning step, thank you very much.

I took the time to understand the operation. and I could not have found it without your help. thank you.

But to have this graphical configuration, it's so complicated and is it really necessary ?
It's a customer request.

Especially since I lose the calculation of the totals, which I also need.