Qlikconfused

[avinashelite]

Your data model has synthetic key that's why its giving wrong results.

Except the ID_WAREH column rename all the keys which share common names in the other table that will resolve the issue

[Anonymous]

Thank you very much I fixed it but that doesn’t resolve my problem

i want to write something like

if TRAFFIC_PLACE=FOA  then take all  ID_WAREH and sum Net Sales

in one line. I don’t want to show results per ID_WAREH

[avinashelite]

you need in the front end ?

try like this

sum({<TRAFFIC_PLACE={FOA}>} [Net Sales])

[Anonymous]

if i write this in expession it will bring only the sales for FOA

[PrashantSangle]

can you explain with sample data ??

if possible provide sample app also??

Regards,

[avinashelite]

Yup

[Anonymous]

   I have this table

TRAFFIC_PLACE	STORE	Traffic  in	Tickets	Net Sales
Bazaar Ag. Stefanos	Outlet Έδρας	1	5	28
Collective Kolonaki	Collective Κολωνάκι	3	5	35
Collective N. Erythrea	Collective Ν.Ερυθραίας	2	4	26
Collective Psichiko	Collective Ψυχικού	2	5	33
FOA	-	41	0	0
GRE001	Nike Γλυφάδας (Βουλιαγμένης)	10	28	209
GRE002	Nike Ψυχικού	4	10	62
GRE005	Nike Κηφισιάς	3	7	52
GRE006	Nike Πάτρας	12	16	182
GRE007	Nike Ν.Ερυθραίας	3	7	44

For the traffic place FOA i want to write somehow in the expresion for Tickets and Net Sales that:

if traffic place =FOA then bring me the Net Sales for ID_WAREH =(5,13,27,46)

[avinashelite]

Try like this

if[TRAFFIC_PLACE] ='FOA',SUM({<ID_WAREH ={5,13,27,46}>}[Net Sales]) ,SUM([Net Sales]))

[Anonymous]

it doesnt work

sorry