Assist me in getting the requirement.

[suvechha_b]

Hi All,

Please kindly assist me in getting the below requirement -

1.Chart -

2.

Data Completeness
Data for 35 of 67 Partners Data in Datawarehouse = 52%
Data for 12 of Top 30 Partners by GPI in Datawarehouse = 40%

Attaching the Excel and sample model.

I have the data presentation in the model like below-

Thanks,

[PrashantSangle]

I did not get your 2nd requirement. For 1st requirement you can try below in pie chart

dimension

>=ValueList('Monthly Claims Data','Daily Claims')

Expression

if(ValueList('Monthly Claims Data','Daily Claims')='Monthly Claims Data',Count({<RB_BATCH_TYPE={'D'}>}RB_BATCH_TYPE),Count({<RB_BATCH_TYPE={'M'}>}RB_BATCH_TYPE))

Regards,

Prashant Sangle

[suvechha_b]

Hi Prasant,

But , if I am doing in excel calculation- I am getting

70.83 %

while in Qliksense I am getting - 91.1 %.

Please will you have a look.

excel file and sample model attached.

[PrashantSangle]

It is because in excel you are considering 

51/72 and 5/72

where it should be consider as 51/56(excluding Not provided flag) and 5/56 

Regards,

Prashant Sangle

[suvechha_b]

Is it possible to do 51/72 and 5/72 instead of 51/56 and 5/56. ?

[PrashantSangle · Accepted solution]

pie chart always ratio in terms of 100%. So in this case some where you have to show 'Not Provided data ' value also.

If you want to show 'Not Provided' Monthly Claims then made change accordingly in valuelist. and measure also

Regards,

Prashant Sangle