Problem with row cofiguration

[#1]

Hi,

i have a problem with a table in qlikview. I would like to have a table with this configuration:

SERVICE  DATA1   DATA2    DATA3

a               num1     num2     num3

b               num4      num5     num6

But if I use a service and data dimension the result is:

SERVICE     DATA      SUBSCRIPTION

a                   DATA1     num1

a                   DATA2     num2 

b                   DATA1     num4 ....

Any solution?

Thanks

[sunny_talwar]

Use a Pivot Table ‒ QlikView and then pivot your DATA dimension to see the output you are looking to get

[PrashantSangle]

Where you want in front end i.e straight table or in back end??

if front end then take service as dimension and

1: Data1 : sum({<Data={"Data1"}>}Subscription)

2: Data2 : sum({<Data={"Data2"}>}Subscription)

and so on

Regards

[qv_testing]

try this,

Cross table (DATA , SUBSCRIPTION)

Load * Inline [

SERVICE  DATA1   DATA2    DATA3

a               num1     num2     num3

b               num4      num5     num6

];

[zhadrakas]

try this expressions

Only({<DATA={"DATA1"}>}SUBSCRIPTION)

Only({<DATA={"DATA2"}>}SUBSCRIPTION)

Only({<DATA={"DATA3"}>}SUBSCRIPTION)

[#6]

No, the range of date(date1, date2...) is an input value.