topic Re: Qlikconfused in QlikView

Qlikconfused

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

Re: Qlikconfused

avinashelite — Mon, 18 Jun 2018 09:48:44 GMT

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

Re: Qlikconfused

Anonymous — Mon, 18 Jun 2018 10:14:24 GMT

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

Re: Qlikconfused

avinashelite — Mon, 18 Jun 2018 10:45:42 GMT

you need in the front end ?

try like this

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

Re: Qlikconfused

Anonymous — Mon, 18 Jun 2018 11:21:07 GMT

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

Re: Qlikconfused

PrashantSangle — Mon, 18 Jun 2018 11:38:39 GMT

can you explain with sample data ??

if possible provide sample app also??

Regards,

Re: Qlikconfused

avinashelite — Mon, 18 Jun 2018 11:42:30 GMT

Yup

Re: Qlikconfused

Anonymous — Mon, 18 Jun 2018 12:51:30 GMT

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)

Re: Qlikconfused

avinashelite — Mon, 18 Jun 2018 13:15:00 GMT

Try like this

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

Re: Qlikconfused

Anonymous — Tue, 19 Jun 2018 06:37:56 GMT

it doesnt work

sorry

Re: Qlikconfused

susovan — Tue, 19 Jun 2018 07:13:08 GMT

First all deselect the option of "Supress-Zero-Values" from presentation tab.

Then put your requisite condition in below said expression

=if(TRAFFIC_PLACE='FOA',Sum(TOTAL{<Traffic_in={'12'}>}#_NetSales),

Sum(#_NetSales)

)

also find the attached file

Re: Qlikconfused

avinashelite — Tue, 19 Jun 2018 07:35:05 GMT

Could you share the sample qvw files ?

Re: Qlikconfused

Anonymous — Tue, 19 Jun 2018 08:05:07 GMT

Yes it worked!!! Thank you very much!

But there is one more thing. In order to have the correct sum in Net Sales,

i have to choose {ΔΕΛΠ ΔΛΠ ΔΛΠ-TF } from the box TR_KIND or else it brings me wrong numbers.

but for TRAFFIC_PLACE] ='FOA i dont have TR_KIND so when i choose the above the FOA is hidden

So what I have to write in the expression in order to fix it!

STOCK

ΔΕΛΠ

ΔΛΠ

ΔΛΠ-TF

ΠΡΟΚ/ΛΗ

Re: Qlikconfused

Anonymous — Wed, 20 Jun 2018 06:41:00 GMT

Good morning!

Can you plz help me with this?

Re: Qlikconfused

susovan — Mon, 25 Jun 2018 04:16:44 GMT

Try this,

=if(TRAFFIC_PLACE='FOA',Sum(TOTAL{<Traffic_in={'12'},TRAFFIC_PLACE=>}#_NetSales),

Sum(#_NetSales)

)