Crosstable formatting

[marakud971]

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.

[Frank_Hartmann]

see attached qvw file.

hope this helps

[marakud971]

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.

[Frank_Hartmann]

see attached

hope this helps

[marakud971]

thanks,

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

QTE and QTE en hl are in the same col.

[Frank_Hartmann]

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

one for QTE and the other for QTE en hl

[marakud971]

okey !!!! yes !!!

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

i can use these expressions ?

[Frank_Hartmann]

OK. I understand.

See attached

[marakud971]

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.

[Frank_Hartmann]

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

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