Total Count per item

[mandilicious]

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

[lanlizgu]

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

[mandilicious]

Hi Liz

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

Thanks

[lanlizgu]

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...

[mandilicious]

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

[lanlizgu]

Could you please share the .qvw?