Discussion Board for collaboration on QlikView Scripting.
hii i am having problem in this
below is a column of my table
in this total count is 19 but i am getting only 15 count of it
in this repeated data is not getting counted
so please help me in this
and give me a code as soon as possible
Add below while loading in script.
RowNo() as ID
Are you doing a distinct count or Count? I think a simple count should get you 19
Simple count(Code) must work.
May be this:
Load * Inline [
RowNo() as RowNumber,
Drop Table Source_Data;
its not working
i am using just count(code) still its not coming
i do not want to load this filed can you suggest other options
The count(CODE) is working. check the attachment..
If normal count is not working try counting with aggr