Button action is not showing exact values

[#1]

Hello,

Can any one see the enclosed qvw file. it explains you my problem.

[swuehl]

I think the reason why you get different results is that you clear selection in defectname in your table chart expression. This will include carid 1039858 in your count, when using the button (note that you use a carid comparison larger than 1039855), while you only select the two carids manually.

You can see this easily by putting this in a text box:

=count({<defectname=>}distinct carid)

(and then remove the set expression).

Hope this helps,

Stefan

[#3]

Tnx stefan to give rly...

i got the solution. Just i add min and max with are in the date range to button.

='>'&1039855 & '<=' & 1039857

[#4]

The solution which i developed is not working for me. Can you help me how to over come this.

Actually what i want is..

In A expression i want to display count of inspid field per cavnum(i.e with all defect FM only).

In B expression i want to display Total count of inspid field per cavnum.(i.e with all defect types what i have).

[swuehl]

Not sure what you want, I haven't understood your data.

Maybe you want to add a distinct to your count in expression A, similar to expression B?