please analyse the data?

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

please find out sample excel sheet and analyse the data.

1)sheet 1:

market,time,type,sale fields available. using below sql query.and market field available string and num vales.so its load only string values.

select sheet1.time, sheet1.market , sheet1.garp_activity_type, sum( d.est_daily_net_sales )

sheet1

where sheet1.time >= '01-Jan-2017'

group by sheet1.time, sheet1.market , sheet1.garp_activity_type

having sum( sales ) <> 0

2)shhet2:fields like below .while loading time how to remove where its come UNKNOWN and -1 and fffff values.

MARKET_GARP_DESC	,MARKET_HFM_CODE_LEVEL1,	MARKET_HFM_SORT_LEVEL1
Moldova	MARKET_NONE	4
UNKNOWN	-1	fffffffffffffffffff
Indonesia	MARKET_NONE	4
Central and Eastern Europe - Overhead	MARKET_NONE	4
Switzerland	MARKET_NONE	4
Bosnia + Herzegovina	MARKET_NONE	4
UNKNOWN	-1	fffffffffffffffffff

and implement below sql query.

2)"select distinct d.market, m.*

from sheet2,

sheet1

where sheet1.market = sheet2.MARKET_GARP_CODE

and

sheet1.time >= '01-Jan-2017'"

3)"select distinct sheet1.garp_activity_type, sheet3.*

from sheet3,

sheet1

where sheet1.garp_activity_type = sheet3.BUSINESS_LINE_GARP_CODE

and sheet1.time >= '01-Jan-2017'"

i don' know any requirements write now.i am going to work on this data.so please understand and how implement the data model and

if any idea about kpi with expressions on above data please send to me.

i shared only less fields in attached doc.if need full data for analyzing please drop a massage below email

chaitanya.mspa@gmail.com

thanks

daisy

Re: please analyse the data?

shiveshsingh — Sat, 10 Feb 2018 12:31:17 GMT

Script for 1:

Sheet1:

LOAD Market, time,

GARP_ACTIVITY_TYPE,

sales

FROM

[..\Desktop\Book1 (2).xlsx]

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

W:load time, Market , GARP_ACTIVITY_TYPE, sum( sales )as sales

resident Sheet1

where time >= '01-Jan-2017'

group by time, Market , GARP_ACTIVITY_TYPE;

drop table Sheet1;

NoConcatenate

Sheet1:load * Resident W

where sales<>0;

drop table W

Re: please analyse the data?

shiveshsingh — Sat, 10 Feb 2018 12:41:59 GMT

And in sheet2, there is no field as MARKET_GARP_CODE

on which field you need inner join of sheet1 and shee2?

topic Re: please analyse the data? in QlikView

please analyse the data?

Re: please analyse the data?

Re: please analyse the data?