Discussion Board for collaboration related to QlikView App Development.
can u please explain a bit?
Because, Count (DISTINCT FieldName) will always return the unique records (Text Object).
But if u want in some other object it might vary.
So explain, in which object/place u want to showcase the distinct values and in what case.
Elaborate more about your query
And Suppose you count any field and there are multiple records then in a straight table take dimension and Count(Dimension)
Expr:- Count(DISTINCT ID) //For unique records
I think, you may be wrong in cases like, you have a dimensions in straight table with ur field name and dates(Attendance date/ Order dates).
It cannot be unique.
The ur field might be applicable for both dates, right?
So john, its better if u explain us a bit.
If you want show count of all records from same List Box
and want to show count of all records other than current selection then use
Indirect Set analysis Like
Or if you want to show count of Other List Box Depend on current selection of List box
=Count (DISTINCT FieldName)
Thank you Mambi Badi. count(distinct YourFieldName) gives you Distict records count. but what i want the records which are extra for these field atrributes.
ex: id value
out put: i am expecting: id value