Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

swiftfahad
New Contributor

finding max stage and delay in process

hi grus....!!!!

I have the following table

Demand_noProcessOrderProcess_dateProcess_id
IT-922Demand001-01-2016sdfdsafs
IT-922IT105-01-2016sdfsafsd
IT-922Tender208-01-2016sdfsadfsdf
IT-922Quotation312-01-2016sdfsdfsxcv
IT-922Po405-02-2016sdfrjgh
IT-922Payment510-02-2016dtyiyum
HR-899Demand014-01-2016ghiyhjgh
HR-899IT118-01-2016yuiyukj
HR-899Tender220-01-2016hnmvbxc
HR-899Po425-01-2016gfhgftyty
DD-2342Demand013-03-2016sdfer
DD-2342IT115-03-2016eertet
DD-2342Tender220-03-2016weregdfgf

now i have shown 3 different demand each of them has different max process..

IT-922 is in payment process

HR-899 is in Po process

DD-2342 is in Tender process

Requirement 1:now i want to show these above maximum process in a table

Demand_noCurrent_Stage
IT-922 Payment
HR-899Po
DD-2342Tender

Requirement 2: I also want a separate table showing delay from each process to another

Demand_noProcess Delay in days
IT-922Demand0ff
IT-922IT4
IT-922Tender3
IT-922Quotation4
IT-922Po23
IT-922Payment5
HR-899Demand0
HR-899IT4
HR-899Tender2
HR-899Po5
DD-2342Demand0
DD-2342IT2
DD-2342Tender5

plzzz help

Tags (1)
5 Replies

Re: finding max stage and delay in process

Create Table 1

Dimension: Demand_no

Expression:

= FirstSortedValue(Process, -ProcessDate)

Create Table2

Dimension:

Demand_no

Process

Expression:

=if(Demand_no<>above(Demand_no),0, Date - above(Date))

Upadate: After seeing Jonathan's reply

MVP
MVP

Re: finding max stage and delay in process

Agree with kush141087‌ for the first table

I would use this expression for table 2:

=If(Demand_no = Above(Demand_no), Date - Above(Date), 0)



Assumes that the Date field is a numeric QV date value.

Re: finding max stage and delay in process

Yes, good catch. I missed that.

swiftfahad
New Contributor

Re: finding max stage and delay in process

Thanks dear jonathan and kushal.. First table is working fine but in second table process are not showing in order. Which causing wrong delay calculation.

proper order is demand,IT,tender,quotation,po,payment

swiftfahad
New Contributor

Re: finding max stage and delay in process

thanks kushal for the replay table 1 is perfect... now can I draw count chart on this table 1?

for example

remember following graph is genrated from table 1 you have advice.I want to show process wise number of demands currently stuck in

process

number of demand
demand2
IT4
tender4
quotation3
po5
payment3