Discussion board where members can get started with QlikView.
i made a cross table in Which i have combine 6 column into one field which is my AGeing column.. now my Ageing values Frequency is increased.. how can i remove Duplicates from them.
use Distinct to remove duplicates
May be try a resident load from your previous table and use a group by statement with the FirstValue function which will give you the first instance of the repetition.
you must add a DISTINCT just after your LOAD, so that you load only different lines