Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
sahibakaur
New Contributor II

Need help in creating output table

Hi All,

I have the following input table, in which I have sales for Nation, Region and its respective territories. I need the output in the following format: (Here I will add a filter of territory, so depending on which territory is selected it will show its sales, it respective regions sales and nation sale in one table. Also, the respective contribution of territory in that region, and contribution of region in Nation.)

    OutPut

AreaSales% Contribution
T111911%
R1   1,126 41%
N   2,749

The input table is:

   

Input
NationRegionTerritorySales
NR1T1119
NR1T2116
NR1T3164
NR1T4198
NR1T5137
NR1T6110
NR1T7124
NR1T8158
NR2T9140
NR2T10200
NR2T11119
NR2T12127
NR2T13186
NR2T14107
NR2T15174
NR2T16198
NR2T17141
NR2T18118
NR2T19113

Appreciate your help.

Thanks

2 Replies
MVP
MVP

Re: Need help in creating output table

Is this output based on certain selection or do you always want to see T1, R1, and N?

sahibakaur
New Contributor II

Re: Need help in creating output table

Only Territory column can be filtered and selected.

territory Is subset of region

Region Is subset of Nation

So there will be a filter for Territory and yes it needs to be shown like above output only. Like T and R and N, depending on which territory gets selected in filter, its respective region will be shown