topic Re: pivot table two dimensions see in single row in QlikView

pivot table two dimensions see in single row

kulasekhar — Fri, 24 Mar 2017 17:54:52 GMT

Hi All,

In pivot table i have two dimensions like bellow.

I want see one ITEM NUMBER(61195643-54) one module Like bellow images.

I Want see any MODULE in one row. like above any one.

Thanks

Sekhar.

Re: pivot table two dimensions see in single row

Anonymous — Fri, 24 Mar 2017 18:27:04 GMT

Do you need only one MODULE for each Item number when expanded?

Re: pivot table two dimensions see in single row

aarkay29 — Fri, 24 Mar 2017 18:27:54 GMT

If you want line by line then you have to use straight table instead of pivot table.

Re: pivot table two dimensions see in single row

kulasekhar — Sat, 25 Mar 2017 02:17:26 GMT

Both should be in dimensions.

Thanks

Sekhar

Re: pivot table two dimensions see in single row

Sat, 25 Mar 2017 03:42:47 GMT

By having Module and Item Number as dimensions and using count in expression for ModuleNo field, the chart could be shown in following format..

Re: pivot table two dimensions see in single row

vinieme12 — Sat, 25 Mar 2017 08:24:50 GMT

Here is a workaround I posted for something similar

Same

You can make it look that way

Change it to a calculated dimension

Dimension1: =ITEMNumber&chr(10)& Module

Dimension2: =Module

Re: pivot table two dimensions see in single row

kulasekhar — Sat, 25 Mar 2017 08:57:15 GMT

Hi Vineeth,

Your shard

LEVEL1 , LEVEL2

ABC ,aa

ABC ,dd

ABC ,mm

I want singile row like bellow

LEVEL1 , LEVEL2

ABC ,aa

( or)

ABC ,dd

(or)

ABC ,mm

Any one row. If there any pasibulities.

Thanks

Sekhar.

Re: pivot table two dimensions see in single row

Anil_Babu_Samineni — Sat, 25 Mar 2017 09:04:28 GMT

What is the logic behind?

Re: pivot table two dimensions see in single row

kulasekhar — Sat, 25 Mar 2017 09:08:45 GMT

there is no logic we want single row like ABC ,aa

Thanks

Sekhar

Re: pivot table two dimensions see in single row

Anil_Babu_Samineni — Sat, 25 Mar 2017 09:11:10 GMT

In fact, Report should need logic. Anyway, For your Question we can achieve like below

LOAD LEVEL1, LEVEL2, AutoNumber(Rowno(),LEVEL1) as ID;

LOAD * Inline [

LEVEL1 , LEVEL2

ABC ,aa

ABC ,dd

ABC ,mm

DEF, fg

DEF,jf

DEF,rt

];

In Pivot Dimension is -- LEVEL1

Expression is -- Only({<ID = {1}>}LEVEL2)

Output this?

Re: pivot table two dimensions see in single row

kulasekhar — Mon, 27 Mar 2017 10:20:35 GMT

Hi Anil,

It's working belloe both Expresstions but showing Null values.

1)Expresstions: =Only({<ID = {1}>} MODULE)

2)Expresstions: =MaxString(MODULE)

Thanks

Sekhar.

Re: pivot table two dimensions see in single row

Anil_Babu_Samineni — Mon, 27 Mar 2017 10:39:30 GMT

Copy the script and use pivot table dimension as LEVEL1 and expression. let's see how this works. Or you may share sample in real data

Re: pivot table two dimensions see in single row

kulasekhar — Tue, 28 Mar 2017 05:45:18 GMT

Hi Anile,

Please find the bellow XL File. That file I have null(#N/A)values. How can i remove.

Thanks

Sekhar.

Re: pivot table two dimensions see in single row

Anil_Babu_Samineni — Tue, 28 Mar 2017 06:19:43 GMT

May be use this

LOAD * From <Excel> Where Len(MODULE)>0;