Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have 2 qvds (traffic – sales) where I take the data for my table (I attach sample data)
For the TRAFFIC_PLACE= FOA in the qvd where I take the traffic I don’t have ID_WAREH and MOVE_TRKIND
and for that reason when I sum(sales) it doesn’t bring me anything.
Also when I choose something from the box MOVE_TRKIND it disappear.
In order to have the right amount of sales, I have to choose from the MOVE_TRKIND= ΔΕΛΠ , ΔΛΠ
and I want my table to bring me for the TRAFFIC_PLACE= FOA the sales of the ID_WAREH=291,322,543
I want to be like this:
MOVE_TRKIND
TRAFFIC_PLACE | ID_WAREH | WAREH_STNAME | Traffic | Sales |
Bazaar Ag. Stefanos | 566 | Outlet Έδρας | 12 | 182 |
Calvin Klein GH | 564 | Calvin Klein Golden Hall | 0 | 11 |
Calvin Klein The Mall | 563 | CK Jeans Mall | 19 | 99 |
Collective Glyfada | 367 | Collective Γλυφάδας | 29 | 364 |
Collective Kolonaki | 649 | Collective Κολωνάκι | 70 | 495 |
Collective N. Erythrea | 138 | Collective Ν.Ερυθραίας | 46 | 396 |
FOA | - | - | 690 | 5.362 |
Collective Psichiko | 707 | Collective Ψυχικού | 53 | 569 |
GRE001 | 29 | Nike Γλυφάδας (Βουλιαγμένης) | 292 | 4.406 |
GRE002 | 14 | Nike Ψυχικού | 172 | 1.149 |
GRE005 | 46 | Nike Κηφισιάς | 92 | 948 |
GRE006 | 1135 | Nike Πάτρας | 227 | 884 |
GRE007 | 471 | Nike Ν.Ερυθραίας | 110 | 811 |
GRE008 | 155 | Nike Πειραιά | 134 | 557 |
GRE011 | 34 | Nike Καλλιθέας | 118 | 829 |
- |
ΔΕΛΠ |
ΔΛΠ |
ΔΛΠ-TF |
Thank you very much for your help!
One way could be to create a forced association:
LOAD CHANNEL,
if(match(ID_WAREH,'291','322','543'),'FOA',TRAFFIC_PLACE) as TRAFFIC_PLACE ,
ID_WAREH,
TRAFFIC_WAREH,
WAREH_STNAME,
if(TRAFFIC_PLACE='FOA',' ΔΕΛΠ',MOVE_TRKIND),
[Traffic in],
Sales
Resident A;
Br,
KC
sorry it doesn't work
I need to write something in the expression inside the chart properties
i wrote
=if(TRAFFIC_PLACE='FOA',count(DISTINCT TOTAL {<ID_WAREH ={543,291,322}>} MOVE_AA),
count(DISTINCT{<MOVE_TRKIND={ΔΕΛΠ,ΔΛΠ}>} MOVE_AA)) and it worked
but when i choose dimension traffic_date in pivot it does't work properly, it repeats the numbers for FOA