Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Distinct Values expression

Hi Folks,

I am facing an issue to calculate distinct values in a expression. In my Table S_Ticket is the Unique field and have amount

now the problem is if adding that unique to some other fields the amount is duplicating...please help me out and find below snapshot for reference. Im expecting output same as in the below snapshot.


2 Replies
Valued Contributor II

Re: Distinct Values expression

Hello Siva,

Trust that you are doing well!

After reviewing the snapshot, amount is listed every time against unique Ticket (First Column). Could you please elaborate more on your requirement? Also, share the application with sample data. This will help us to better understand the current situation.



Valued Contributor III

Re: Distinct Values expression

I suppose, that "Ouput" is an "aggr() - expression".

Then you could use aggr(nodistinct ...) perhaps...

For further information you'll have to contribute a small example.

Community Browser