Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kpapanik
Contributor III
Contributor III

Issue with data

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!

0 Replies