Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
devarasu07
Not applicable

Dimensional value split into multiple column in Table view?

Hi,

Can you advise me on how to show below expected output using Straight table? Thanks

Capture.JPG

I've tried below set expression and it's not getting desired output like above.

sum({<Shop=P({<Shop={'Warehouse'}>}Product)>}SOH)

//sum( {$<Shop = P({1<Shop={'Warehouse'}>})>} SOH )

//=SUM( {<Category = P({<Category ={'WHS'}>} ) >}  SOH)

//sum({<Category={'WHS'}>}SOH)

//sum({<Shop={'Warehouse'}>}SOH)

Thanks,

Deva

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Dimensional value split into multiple column in Table view?

Have a look at the attached

Capture.PNG

4 Replies
sunny_talwar
Not applicable

Re: Dimensional value split into multiple column in Table view?

Have a look at the attached

Capture.PNG

devarasu07
Not applicable

Re: Dimensional value split into multiple column in Table view?

That's you Very brilliant solution

devarasu07
Not applicable

Re: Dimensional value split into multiple column in Table view?

Hi stalwar1

Tried to implement the same mock logic into original report and ranking not working as expected. kindly help me to advise me on this issue. Thanks

Created below kind Cal.Dimension:

=IF(Aggr(Rank(SUM({<Year={$(vCurrentYear)},Week={$(vCurrentWeek)},SoldQty={">0"}>}SoldQty),4),StoreName,ArticleNo)<=10,

aggr(RANK(sum({<Year={$(vCurrentYear)},Week={$(vCurrentWeek)},SoldQty={">0"}>}SoldQty),4),StoreName,ArticleNo))


in Expression, also if we included the Year, week filter then the below two expression is not working. just shows results as 0


Store SOH:

sum({<ShopCategory-={'WAREHOUSE'}>}soh)


WH SOH:

(Sum(TOTAL <ArticleNo>  soh)  - sum({<ShopCategory-={'WAREHOUSE'}>}soh)) *  Avg({<ShopCategory-={'WAREHOUSE'}>} 1)


Capture.JPG

sunny_talwar
Not applicable

Re: Dimensional value split into multiple column in Table view?

What will be the expected output? It might help to know what is needed to help better