Issue with data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

ΔΕΛΠ

ΔΛΠ

ΔΛΠ-TF

Thank you very much for your help!

Re: Issue with data

jyothish8807 — Mon, 25 Jun 2018 07:23:05 GMT

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,

Anonymous — Mon, 25 Jun 2018 10:08:56 GMT

sorry it doesn't work

I need to write something in the expression inside the chart properties

Anonymous — Mon, 25 Jun 2018 12:50:04 GMT

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