Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RishabhTFC
Contributor III
Contributor III

Get One Dimension Value

Hi all,

Please help me in this

I am trying to get the Sum(sales) and Sum(Qty) of Dimensions of one sheet:

- I have two sheets :

First Sheet : Contains Sales of Items(No. of Items can be x Amount) :

Item Name Sales
Apple 250
Mango 150
Orange 300
   
   

Secone Sheet :  Contains Stock of Qty of Items:

Item Name Qty
Apple 10
Mango 8
Orange 12
Guava 8
Melon 6

 

When I Load the Sheet the Item Name the two sheets connected with a unique key i.e. Item Name.

Now I want the Output table to show Sum(sales) and sum(Qty) of each respective item but do not want the item of Second sheet in my Dimension I just want the Data of First sheet only but the item name is now unique so it shows all the value of that dimensions. 

Any one help me on this please

 Thanks

RM

 

 

Labels (2)
1 Reply
Ezir
Creator II
Creator II

Hi @RishabhTFC ,

Is this the expected result?

Item NameSalesQty
Apple25010
Mango1508
Orange30012

 

For this...

 

LOAD *
[...First Sheet]

INNER JOIN

LOAD *
[...Second Sheet]

 

 

Best regards,

 

Ezir