topic Re: Using previous values in Straight table-Where first value is "Hardcoded" in QlikView

Using previous values in Straight table-Where first value is "Hardcoded"

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

Hi All,

i am developing below table:

Expression -Capacity Baseline -Storage has july month values hard-coded(manually inputted).Now,from the next month("Aug") ,value should be calculated as followed:-

Capacity Baseline -Storage Value of Current Month = Capacity baseline storage of previous month + BAU of previous month +SCR of previous month+ Limewood of previous month+reclaim of previous month.

Example- Aug month should have Capacity Baseline Storage value as 1101 under VSP and 184 under HUS.

All the above mentioned Names are Expressions with below logic:-

BAU = COUNT({<[Change type*]={'Allocation'},[BAU/SCR/Project]={'BAU'}>}[Volume (in GB)*])

SCR = COUNT({<[Change type*]={'Allocation'},[BAU/SCR/Project]={'SCR'}>}[Volume (in GB)*])

RECLAIM = COUNT({<[Change type*]-={'Allocation'}>}[Volume (in GB)*])

How can this be achieved.

Re: Using previous values in Straight table-Where first value is "Hardcoded"

sunny_talwar — Mon, 09 Jan 2017 12:00:19 GMT

Would you be able to share a sample to look at this?

Re: Using previous values in Straight table-Where first value is "Hardcoded"

Pulkit_Thukral — Mon, 09 Jan 2017 12:13:27 GMT


					20-Jul-16

Storage system*	Change type*	BAU/SCR/Project	Volume (in GB)*	Implementation date*
VSP	Allocation	BAU	300	5-Jul-16
VSP	Allocation	BAU	500	6-Jul-16
VSP	Allocation	BAU	515	6-Jul-16
VSP	Allocation	BAU	40	11-Jul-16
VSP	Allocation	SCR	980	14-Jul-16
VSP	Reclaimation	SCR	500	18-Jul-16
VSP	Reclaimation	BAU	10	18-Jul-16
HUS	Allocation	BAU	20	19-Jul-16
HUS	Allocation	BAU	450	19-Jul-16
HUS	Reclaimation	Iscr	250	20-Jul-16
HUS	Reclaimation	SCR	240	20-Jul-16

Re: Using previous values in Straight table-Where first value is "Hardcoded"

Pulkit_Thukral — Tue, 10 Jan 2017 05:57:14 GMT

Were you able to try with the sample data Sunny ?

Re: Using previous values in Straight table-Where first value is "Hardcoded"

Pulkit_Thukral — Tue, 10 Jan 2017 16:24:22 GMT

i was able to solve this with the help of above function.Thanks