Levels in Pivot table in Qliksense

[SunainaUmberkar]

Hello All,

I have a scenario like below.

We have some levels defined and each materials has some levels defined in it.
We have level field from 1 to 12 and Materials against them. We have one more levelnew field
starting from Level 2, under this Level 2 we need to display Materials with Level 2.

Consider below example, I want to show pivot table like below. Under BA00003589668, BA00002460360 must be displayed. Under BA00002460360 -- BA00002473290 and BA00002490203 must be displayed. 

Can we display in this format in pivot table in Qliksense? Kindly assist. I have also attached the sample data in excel.

[justISO]

Hi, while comparing your added picture and data sample, at least for me it is hard to understand the logic how you want to represent values according your level. For example, for 'Material 1' BA00002460360, how only 2 values goes? Is it for 1 level2 material, goes 2 level3 materials and so on?

Talking about format in pivot table, probably you can try to create your pivot with created few columns for each level, like

=if(HLVL_1=X, MATNR_1,'')

where X is your level, 2,3,4... And in Appearance->Presentation check 'Fully expanded' and uncheck 'Indent rows'. View should look similar to in picture.

[SunainaUmberkar]

Hello justISO,

Thanks for the reply.

Let me explain the scenario. I have a data with respect to levels. For each level we have materials associated.

I have attached 2 excels.

1st excel- This data is for level 1 , where materials are mapped for each level and have material description.

2nd excel- This data is from Level 2 onwards,here materials are mapped from Level 2 and have material description against each.

For Level,Material and description we have different fields for both excel level1 and level 2.

In pivot table, i am getting like in the attached pivot table excel. From excel 1, i have displayed Level1 field and then material column. Then from2nd excel i have displayed Level2 and Material2. Now under Material2 i need to get level3 materials from 2nd excel. For ex, BA00002460360 under this i need to get BA00002473290 material(this is level 3 material) and so on. 

Also find the ss of pivot table.