topic Re: Total Count per item in QlikView

Total Count per item

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

Hi All

Please assist

I need to display data like below

(1) but mine is like below I need to display only Building, car,Contants,portable Possessions

I used this set analysis but it doesn't t work

Exp:=Count({<RecItemDescription ={"Building","car","Contants","portable Possessions"}>} RecCaseNo)

(2) My data display like below which look fine but when I click calendar it is not dynamic it remain the same?

Exp:=Count({<RecRepudiationReason ={"No cover"," Claim Withdrawal (NCR)","Claim within excess", "Claiming from 3rd party", "Not taken up"}>} Claim_Item_No)

Thanks

Re: Total Count per item

lanlizgu — Thu, 27 Sep 2018 08:17:17 GMT

try ' instead of ". Could you please also ensure that you are writing the words in the same way as in the database?

Re: Total Count per item

mandilicious — Thu, 27 Sep 2018 08:38:04 GMT

Hi Liz

Can you please give me an example on that using my exp?

Thanks

Re: Total Count per item

lanlizgu — Thu, 27 Sep 2018 09:22:19 GMT

based on your first expression you should use

Count({<RecItemDescription ={'Building','car','Contants','portable Possessions'}>} RecCaseNo)

However, if values are not correct in the expression (car) based on the database (Car) you would be inheriting these errors...

Re: Total Count per item

mandilicious — Thu, 27 Sep 2018 11:02:50 GMT

Hi Liz

I have checked values are correct but still not working I am still getting below results

Exp:=count({<RecRepudiationReason={'No cover','Claim Withdrawal (NCR)','Claim within excess','Claiming from 3rd party','Not taken up'}>} PAYAmountPaid)

Results and I need only {'No cover','Claim Withdrawal (NCR)','Claim within excess','Claiming from 3rd party','Not taken up'}

Exp:count({<RecRepudiationReason={'No cover','Claim Withdrawal (NCR)','Claim within excess','Claiming from 3rd party','Not taken up'}>} PAYAmountPaid)

Thanks

Re: Total Count per item

lanlizgu — Thu, 27 Sep 2018 11:23:44 GMT

Could you please share the .qvw?