Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Help on -> getting the correct value through grouping or set analysis?

ITEM

COMPANYBRANDON-HAND-QTYCTN
item2comp1A2010
item3comp1A455
item4comp1A7015
item1comp1A3020
item1comp2A2520

Above is the current result & the below is the excel file.

ITEMCOMPANYCTN
item1comp112
item1comp220
item2comp110
item3comp15
item4comp115

I wanted to make the result to become something like this...

Header 1Header 2Header 3Header 4Header 5
item1comp1A3012
item1comp2A2520

I have try,

Max({<QUANTITY_UM={"CTN"}, ITEM, COMPANY>}CONVERSION_QTY)

//sum(if (QUANTITY_UM='CTN', CONVERSION_QTY, 0) )

//if (QUANTITY_UM='CTN', Sum(CONVERSION_QTY), 0)

but the result is not what I want. Please help.

Tags (1)
3 Replies
balrajahlawat
Esteemed Contributor

Re: Help on -> getting the correct value through grouping or set analysis?

What is the difference b/w these two tables??

For me both are same except two more columns in above table, Brand, ONHandQty

any other difference?

If both are two different tables, try to concatenate or Join()

darkhorse
Valued Contributor

Re: Help on -> getting the correct value through grouping or set analysis?

Hello,

Header4 = sum({<Header1={'item1'}>}Header4)

Header5 = sum({<Header1={'item1'}>}Header5)

BR

Serhan

MVP
MVP

Re: Help on -> getting the correct value through grouping or set analysis?

Hi,

Try like this

Data:

LOAD

*

FROM Table1;

Left Join(Data)

LOAD

ITEM,

COMPANY,

CTN AS CTN_NEW

FROM Table2;

Now in chart use like below

Dimension: ITEM, COMPANY, BRAND

Expression: Sum([ON-HAND-QTY]), Sum(CTN_NEW)

Hope this helps you.

Regards,

Jagan.

Community Browser