Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a single table in load statement. It has some measures and dimension (attributes).
Country
Region
State
State ID
Sales
I want to display a report with Country & Sales Income only. I do that but when i see the report on IE it repeats the country value for all stateID's. I just want to see one row per country with sum(Sales). It is a simple group by in SQL but I don't want to do it on LOAD statement as I want to use the state info in another tab.
Hi,
Add Country as Dimension in chart and use =Sum(Sales) as Expression.
This will show Country and their corresponding sales.
Hope this helps you.
Regards,
jagan.
Dear,
find the attachment.
Dear All ,
Let me explain again what I want:
My qlickview dataset
Customer ID | Customer Name | Product ID | Product Name | Country | Qty-Ly | Qty-CY |
1 | ABC Inc | 101 | Shoes | Japan | 1 | 2 |
2 | ABC Inc | 102 | Shoes | Japan | 2 | 3 |
3 | ABC Inc | 103 | Shoes | Japan | 5 | 7 |
4 | XYZInc | 110 | jackets | China | 4 | 10 |
5 | XYZInc | 110 | jackets | China | 5 | 11 |
I am using a Table object and only picking the following data items: |
Customer Name |
Product name |
Country |
Qty-Ly |
Qty-CY |
The following data is displayed in Qlikview
Customer Name | Product Name | Country | Qty-Ly | Qty-CY |
ABC Inc | Shoes | Japan | 1 | 2 |
ABC Inc | Shoes | Japan | 2 | 3 |
ABC Inc | Shoes | Japan | 5 | 7 |
XYZInc | jackets | China | 4 | 10 |
XYZInc | jackets | China | 5 | 11 |
What I really want
Customer Name | Product Name | Country | Qty-Ly | Qty-CY |
ABC Inc | Shoes | Japan | 8 | 12 |
XYZInc | jackets | China | 9 | 21 |
How to achieve it without modifying the Load statement?
Hi,
Use CustomerName, ProductName, Country as dimensions and use
=Sum(Qty-Ly)
=Sum(Qty-CY)
as expressions
Regards,
Jagan.
Hi,
Use Straight table instead of table box.
Have dimensions CustomerName, ProductName, Country.
Have expressions below
=Sum(Qty-Ly) give label for this as Qty-Ly
=Sum(Qty-CY) give label for this as Qty-CY
Celambarasan