Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kulasekhar
Contributor

pivot table two dimensions see in single row

Hi All,

In pivot table i have two dimensions like bellow.

asdf.JPG

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

asdf2.JPG         asdf3.JPG

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

Thanks

Sekhar.

13 Replies
laddu_927
Valued Contributor

Re: pivot table two dimensions see in single row

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

aarkay29
Valued Contributor

Re: pivot table two dimensions see in single row

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

kulasekhar
Contributor

Re: pivot table two dimensions see in single row

Both should be in dimensions.

Thanks

Sekhar

Not applicable

Re: pivot table two dimensions see in single row

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

vinieme12
Esteemed Contributor II

Re: pivot table two dimensions see in single row

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

kulasekhar
Contributor

Re: pivot table two dimensions see in single row

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

What is the logic behind?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kulasekhar
Contributor

Re: pivot table two dimensions see in single row

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

Thanks

Sekhar

Re: pivot table two dimensions see in single row

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?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)