topic Re: Logic in QlikView

Logic

Sat, 07 Nov 2015 19:35:44 GMT

Hi,

How can we minus the dates .ie in below excel i want to do minus like [Current-Date -Joining-Date] then average .

Requirement:

i want to know in how many days an employee is moving to higher position like [L1-L2]

Output :average days took to go to L1-L2 Position

Plz Help me

Re: Logic

swuehl — Sat, 07 Nov 2015 20:12:50 GMT

Load the data from your excel file:

DATA:

LOAD [Emp-Id],

[Joining-Date],

Position,

[Current-Date],

[Current-Positin]

FROM

[Analysis.xlsx]

(ooxml, embedded labels, table is Sheet1);

Then create a text box with this expression to calculate the average days

=Avg( [Current-Date]-[Joining-Date] )

edit: simplified the expression

Re: Logic

Sun, 08 Nov 2015 02:39:31 GMT

thanku Swuehi.

in text box i want like this:

how many days it required for changing Designation like L1-L2 only in excel i have L2-L3 so on but i want only for L1-L2

Re: Logic

HirisH_V7 — Sun, 08 Nov 2015 07:52:34 GMT

Hi,

you can use some thing like this,

=if(GetFieldSelections([Emp-Id]),[Joining-Date] & ' '& [Current-Date] & ' ' & Count([Current-Date]-[Joining-Date]) & ' Days Difference' & Position & ' '

& [Current-Positin] & ' ' ,

'Select EMPID')

Hope this helps,

Thanks,

hirish

Re: Logic

swuehl — Sun, 08 Nov 2015 11:27:39 GMT

Ok, I think I understand now better.

Just use above expression in a text box, then select L1 in Joining Position and L2 in Current Position list boxes?

If you want a chart to show all upgrades, maybe create a straight table chart with two dimensions:

[Position]

=if(Mid([Current-Positin],2,1)>Mid([Position],2,1),[Current-Positin])

Enable 'Suppress when value is NULL' for second dimension on dimension tab.

Use as expression again:

=Avg( [Current-Date]-[Joining-Date] )

If you only want to show a fixed KPI for L1 to L2 upgrades in a text box:

=Avg({<[Current-Positin] = {"L2*"}, Position = {"L1*"}>} [Current-Date]-[Joining-Date] )