Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

how to show single time group name instead of multiple times in straight table

Hi All,

i have two groups with hierarchy level

 

level 1 like owner of the group

level 2 is next manager 

level 3  is employee

 

when i show in the chart 

for level 2 and level 3 it shows like below

Capture.PNGbut i need in level 2 it shows once bill Simmons name and under it show reaming list

like same to fuyu also

i want to print only one time in level 2 names instead of multiple times

like below.

Capture1.PNG

please suggest us  ASAP.

 Thanks In Advance

8 Replies
Highlighted
Contributor II
Contributor II

Best way of presenting this is in PIVOT Table, that has the way of presenting the data in a table as your expected output.
Highlighted
Creator
Creator

HI Kishore ,

but here issue is only with level 2 only reaming fields and all other tables coming properly for this.

i'm using below ex pr as a dimension
=if(SO_SRH=3, SO_Group)

please suggest me.

 

Thanks in Advance.

 

 

Highlighted
Contributor II
Contributor II

can you attach the sample qvw
Highlighted
Creator
Creator

 
Highlighted
Creator
Creator

my file more than 200mb

 

i just sending silimer type file

Thanks

Highlighted
Creator
Creator

 
Highlighted
Creator
Creator

HI All,

 

i'm using for level 2(is a label) as calculated dimension

level 2 is label name

Dimension is ==(if(AO_DimOVSRH=3,AO_DimOVAccountOwner))

please suggest how to proceed.

slimler way level 1 also i need to follow.

 

Please suggest me its urgent to me.

Highlighted
Creator
Creator

Hi All,

 

Could you please suggest how to hide the repeated value fro conditional Dimension s in straight table

ASAP

 

Thanks Ina Advance