topic Re: how to combine two dimension value into one column? in QlikView

how to combine two dimension value into one column?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: how to combine two dimension value into one column?

Tue, 18 Apr 2017 01:22:05 GMT

Hi Deva,

Please see screenshot below and qvw attached. Any good?

Warm regards,

Nish

Re: how to combine two dimension value into one column?

devarasu07 — Tue, 18 Apr 2017 01:45:06 GMT

Many Thanks

Re: how to combine two dimension value into one column?

Tue, 18 Apr 2017 01:46:28 GMT

Thank you!

Re: how to combine two dimension value into one column?

devarasu07 — Fri, 28 Apr 2017 03:13:54 GMT

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

Re: how to combine two dimension value into one column?

sunny_talwar — Fri, 28 Apr 2017 08:16:48 GMT

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

Re: how to combine two dimension value into one column?

devarasu07 — Fri, 28 Apr 2017 08:36:19 GMT

Re: how to combine two dimension value into one column?

sunny_talwar — Fri, 28 Apr 2017 08:38:48 GMT

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

Something like this?

Re: how to combine two dimension value into one column?

devarasu07 — Fri, 28 Apr 2017 08:47:50 GMT

Hi Sunny,

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

Thanks

Re: how to combine two dimension value into one column?

sunny_talwar — Fri, 28 Apr 2017 08:50:28 GMT

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