I have a table of three values year,in a year some models,in a model some sl no.,..My problem is there are some sl no. which are repeated in more than 1 model.. I need to find out which sl no. are repeated..
My structure is like
year----model---slno.
I need to cascade the espression to find dose values.
Load data into QlikView, then create a chart straight table with a dimension slno and one expression COUNT(DISTINCT model). It will give you a report for each slno, how many models it is in. Then sort it by this expresion descending and these slno's with more than 1 model will be at the top.
Load data into QlikView, then create a chart straight table with a dimension slno and one expression COUNT(DISTINCT model). It will give you a report for each slno, how many models it is in. Then sort it by this expresion descending and these slno's with more than 1 model will be at the top.
