Chart representation ?

[suvechha_b]

Hi All,

How to do this count in chart in Qliksense ?

expression : Count({$<[Partner Grouping Name]={'Personal & Commercial'},[Claims Captured Month]=>}
Distinct [Claims Captured Claim Number])

How to do the count for all whole Months- i.e from Jul-19 to Jun 18 and show them in graph in Qliksense.

Please see the excel  file attached.

sample model attached.

[Arthur_Fong]

Your sample data seems not complete.

Can you provide your partner data as well?

And the Excel value seems different with the one you created in QS.

Did you missed out any filter that is required?

Also, how do you define Motor and Non-Motor Groups?

[suvechha_b]

Hi ,

Excel is a sample ,

My requirements is I want the count of Count(Distinct [Claims Captured Claim Number]) for last 12 months

Motor and Non- motor , I am using field [Section Latest]

new sample attached.

[Arthur_Fong]

Try this :

Count(Distinct {<CLAIMS_CAPTURED_MONTH_NAME={">=$(=MAX(CLAIMS_CAPTURED_MONTH_NAME)-12)"}>} [Claims Captured Claim Number])

[Arthur_Fong]

A little adjustment to ignore month selection:

Count(Distinct {<CLAIMS_CAPTURED_MONTH_NAME={">=$(=MAX(CLAIMS_CAPTURED_MONTH_NAME)-12)"},[Claims Captured Month]=>} [Claims Captured Claim Number])

[suvechha_b]

Sorry , it is not working-giving a value 201897 . and what should be in dimension.

I am getting like this-

But I want like this-

Please can you implement on the sample model and send it through.

Many Thanks,

[Arthur_Fong · Accepted solution]

 QVF attached.

Take a look at Past12Months chart.

[suvechha_b]

Hi Jkfong93,

Please assist me in getting the count of distinct claims for last 12 months in pie chart like below.

[Arthur_Fong]

Isn't this what is shown like your example?

[Arthur_Fong]

In edit mode, select the pie chart, go to appearance > presentation > select pie.