topic Re: Problem with row cofiguration in QlikView

Problem with row cofiguration

Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 25 Jul 2017 12:46:18 GMT

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

PrashantSangle — Tue, 25 Jul 2017 12:47:19 GMT

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

Nagaraju_KCS — Tue, 25 Jul 2017 12:51:04 GMT

try this,

Cross table (DATA , SUBSCRIPTION)

Load * Inline [

SERVICE DATA1 DATA2 DATA3

a num1 num2 num3

b num4 num5 num6

];

zhadrakas — Tue, 25 Jul 2017 12:52:03 GMT

try this expressions

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

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

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

Tue, 25 Jul 2017 12:55:38 GMT

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