Protected: Smpeta Burning Issues

This content is password protected. To view it please enter your password below:

Advertisements

Listening Skills

 

1. Pay Attention: Eye contact and take notes
2. Stay Focused
3. Paraphrase
4. Give feedback
5. Be Genuinely Interested
6. Pay Attention to Non-Verbal Cues
7. Learn To Shut Up
8. Don’t Multi-Task
9. Avoid Offering Advice
10. Don’t Steer The Conversation

1. PRACTICE ACTIVE LISTENING.
Firstly close your mouth, & open your ears
Always be in present fully, be in the moment ! Be attentive

Don’t try to cut or interrupt just to showcase your point ! You should always go by 80% listening and 20% Talking ratio.

Don’t be too quick to respond ~ be patient.
1- Attentively listen to other person-
2- Ask questions
3- Never judge
4- Repeat in your own words
5- Assume yourself at their place-

Oka Vijetha

Capture.PNG

 

 

S.No Name Amount
1 Barigela Vinod Kumar 300
2 Chintala Narendra 200
3 Fridge Subhani 200
4 Gandam Chandrasekhar
5 Govindarajula Bhadra 2000
6 Jonnabhatla Venkata Kishore 500
7 Juneboyina Arjunarao 5000
8 Kakanaboyina Murali 500
9 Kakanaboyina Nagaraju 500
10 Manimaddi Brahmam 400
11 Pakide Dharmaji 200
12 Palleboyina Brahmam 3×3 sets books
13 Ponneboyina Siva 1000
14 Potu Gopalarao One magazine 1 yr subscr
15 Potu Laxminarayana 300
16 Ramisetti Saidulu 200
17 Saranam Koteswara Rao 500
18 Sayyad Abdul 200
19 Shaik Nabi Saheb 500
20 Simmasarthi Tirupatirao 100
21 Sunkireddy Upender Reddy 1000
22 Shaik Esub 200
13,800

Create master calendar from Fact table in Qlikview

http://www.eenadu.net/homeinner.aspx?category=home&item=break43

We may not have the data for all the dates in Fact Table. We will check the data on date/month/quarter/year time-frame.

We can create master calendar without depend on Fact table or by taking min date and max date.

In general it is best practice to create master calendar based on Fact table date.

For example, We have a simple Fact Table Sales made by a Customer on daily basis.

Let us create a master calendar based on this.

SalesFactData:
LOAD Date(Date#(Date,'DD-MMM-YY')) as Date,EmployeeName,Sales inline [
Date,EmployeeName,Sales
1-Jan-17,E1,1
2-Jan-17,E1,2
3-Jan-17,E1,3
4-Jan-17,E1,1
5-Jan-17,E1,2
1-Jan-17,E2,3
2-Jan-17,E2,1
3-Jan-17,E2,2
4-Jan-17,E2,3
5-Jan-17,E2,1
1-Feb-17,E1,2
1-Feb-17,E1,3
1-Feb-17,E1,1
1-Feb-17,E1,2
1-Feb-17,E1,3
1-Feb-17,E2,1
1-Feb-17,E2,2
1-Feb-17,E2,3
1-Feb-17,E2,2
1-Feb-17,E2,3
1-Jan-18,E1,1
2-Jan-18,E1,2
3-Jan-18,E1,3
4-Jan-18,E1,1
5-Jan-18,E1,2
6-Jan-18,E2,3
7-Jan-18,E2,1
8-Jan-18,E2,2
9-Jan-18,E2,3
10-Jan-18,E2,1
1-Feb-18,E1,2
2-Feb-18,E1,3
3-Feb-18,E1,1
4-Feb-18,E1,2
5-Feb-18,E1,3
6-Feb-18,E2,1
7-Feb-18,E2,2
8-Feb-18,E2,3
9-Feb-18,E2,2
10-Feb-18,E2,3
];

 

SalesFactTableData:
LOAD Country,
Date as _DATE_KEY,
Date as DATE, 
EmpNo, 
EmployeeName, 
Sales FROM SalesFactTableData.qvd(qvd);
// custom function to calculate month difference, can be used in expression too
SET MonthDiff = Num(((year($2) * 12) + month($2)) - (((year($1) * 12) + month($1))));
SET vMaxMonth=13;
// to use in expression: =$(MonthDiff(Today(), Today() + 65))
MinMaxTemp: 
LOAD   min(DATE) as MinDate1, max(DATE) as MaxDate1 Resident SalesFactTableData;
MinMax:
load date(floor(monthstart(max(MaxDate1), -$(vMaxHistoricalMonth)))) as MinDate, max(MaxDate1) as MaxDate resident MinMaxTemp;
drop table MinMaxTemp;
let vGlobalMinDate = num(Peek('MinDate', 0, 'MinMax'));
//let vGlobalMinDate = num(date('1/1/2017')); 
// this is to make sure the first month is Jan 2017
let vGlobalMax = num(Peek('MaxDate', 0, 'MinMax'));
let vToday = Date(Peek('MaxDate', 0, 'MinMax'));
Let vCurrentMonth = text(Date(Peek('MaxDate', 0, 'MinMax'), 'MMM'));
TempCal:
Load date($(vGlobalMinDate) + rowno() - 1) As TempDate AutoGenerate $(vGlobalMax) - $(vGlobalMinDate) + 1;
Drop table MinMax;
MasterCalendar:
Load date(TempDate) as _DATE_KEY,
TempDate as Date,
Day(TempDate) as Day,
Week(TempDate) as Week,Year(TempDate) as Year,Month(TempDate) as Month,Weekday(TempDate) as WeekDay,dual(text(Date(floor(monthstart(TempDate)), 'MMM-YY')), $(MonthDiff($(vGlobalMinDate), TempDate))) as MonthYear, $(MonthDiff($(vGlobalMinDate), TempDate)) as MonthNumber Resident TempCal Order by TempDate ASC;
drop table TempCal;

Incremental Load Qlikview – Help Example

Show time in Excel file: =TEXT(TODAY(),”d-mmmm-yyyy”)&” “&TEXT(NOW(),”h:mm AM/PM”)

Data:

PrimaryKey X Y ModificationTime
pk1 x1 y1 12/23/2017 0:00
pk2 x2 y2 12/23/2017 0:00

First Load:

QV_Table:
LOAD PrimaryKey, X, Y, ModificationTime
FROM File.xlsx (ooxml, embedded labels, table is Data);
STORE QV_Table into File.qvd(qvd);
Let LastExecTime = num(Now());

pk2 row is updated X,Y values to x22,y22

PrimaryKey X Y ModificationTime
pk1 x1 y1 12/23/2017 0:00
pk2 x2 y2 12/23/2017 0:00
pk2 x22 y22 12/28/2017 15:59

Incremental Script:

Let ThisExecTime = num(Now());
QV_Table:
LOAD PrimaryKey, X, Y, ModificationTime
FROM File.xlsx (ooxml, embedded labels, table is Data)//; EXIT Script;
WHERE num(ModificationTime) >= $(LastExecTime)
AND num(ModificationTime) < $(ThisExecTime);
Concatenate 
LOAD PrimaryKey, X, Y, ModificationTime
FROM File.qvd (qvd)
WHERE NOT EXISTS(PrimaryKey);
Inner Join 
LOAD PrimaryKey
FROM File.xlsx (ooxml, embedded labels, table is Data);

If ScriptErrorCount = 0 then 
STORE QV_Table INTO File.QVD;
Let LastExecTime = ThisExecTime; 
End If
//EXIT Script;