topic Re: values not populating in QlikView

values not populating

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

dear all,

I have a data like shown below. that data is for 24 months which shows claims and settled claims. but the problem is , for settled I am getting total value at the 24 month, rest is showin zero. my requirement is it should populate data for each month

how to do it?

Re: values not populating

sagarkharpude — Wed, 05 Jul 2017 07:01:37 GMT

can you share the data.

Re: values not populating

PrashantSangle — Wed, 05 Jul 2017 07:03:08 GMT

What was the logic to calculate settle???

Is there any field available in your source to identify settled value for year?

provide more details

Regards

Re: values not populating

stonecold111 — Wed, 05 Jul 2017 07:10:29 GMT

Populate means... What data it should populate... what is the expression you are using for settled??

Re: values not populating

Anonymous — Wed, 05 Jul 2017 07:13:47 GMT

heres d logic:

(ROUND(Sum({<[Common Sales Date]={">=$(=vCommonMinDate)<=$(=vCommonMaxDate)"},MIS={"$(v_MIS_Range_Max)"}>} [Sales Quantity])))

//v_Mis_range_max =if(GetSelectedCount(MIS)=0,24, max(MIS))

// MIS is months

Re: values not populating

stonecold111 — Wed, 05 Jul 2017 07:20:53 GMT

when there are no selections made, it will just display only for MIS=36. that's y it is not populating data.

try to remove that and see or else

just use [Sales Quantity]

Re: values not populating

stonecold111 — Wed, 05 Jul 2017 07:22:23 GMT

sorry MIS=24

Re: values not populating

stonecold111 — Wed, 05 Jul 2017 07:24:43 GMT

(ROUND(Sum({<[Common Sales Date]={">=$(=vCommonMinDate)<=$(=vCommonMaxDate)"}>}[Sales Quantity]))

Use this

Re: values not populating

stonecold111 — Wed, 05 Jul 2017 07:28:12 GMT

round([Saes Quantity]) is the best option