how to combine two dimension value into one column?

[devarasu07]

Hi All,

Please refer to the attachment, I'm trying to calculate repeat Contribution using Stock Type and Repeated Status wise.

Issue: how to achieve below screen shot expected output format (need to combine two dimension (Repeat_Status & Stock_Type) into one dimensional value.

What i've tried, tried to created pivot table calculated measure (refer current output).but expected format not coming? will qlikview will support below expected output format ? kindly advise. Thanks

Thanks,
Deva

[#2 · Accepted solution]

Hi Deva,

Please see screenshot below and qvw attached. Any good?

Warm regards,

Nish

[devarasu07]

Many Thanks

[#4]

Thank you!

[devarasu07]

stalwar1‌ @charismatic97

how to  apply below Calculated measure as Repeat Status

Finding repeat Status flag rule:

=aggr(if(sum({<Year=,Week=,StoreName=>}SoldQty) > sum({<Year={'*'},Week={"*"},Type_ID={'NB'},StoreName=>} OrderQty), 'Repeat','No Repeat'),ArticleNo,Countries)

how to change below conditional statement using above expression.

=If(pick(match($Field,'StockType','Repeat_Status'),StockType,Repeat_Status)=1,'Repeat',

If(match(pick(match($Field,'StockType','Repeat_Status'),StockType,Repeat_Status),0,'Obsolete'),null(),

(pick(match($Field,'StockType','Repeat_Status'),StockType,Repeat_Status))))

Thanks,
Deva

[sunny_talwar]

Not sure I follow your question... would you be able to elaborate a little?

[devarasu07]

[sunny_talwar]

Based on the sample you have above, what is the output are you expecting to see?

Something like this?

[devarasu07]

Hi Sunny,

Can you share the expression. for the figure i have check it out again. Thanks.

Thanks

[sunny_talwar]

That is the thing I have not changed anything... I used what you gave.... attaching the qvw