if accNo. is the same and the prod class is the same select first

[Anonymous]

Hi,

is it possible to do the following in QlikView and if so how please.

If AccNo. is listed more than once,  and if Product type is the same,  don't include bottom row in dashboard results.

Therefore in the following list,  line 2 would not show up in results.

Lineno.	AccNo.	ProductNo.	ProductType
1	50025	Blue Ball	Ball
2	50025	Yellow Ball	Ball
3	50060	Kyte	HandGame
4	500700	Yoyo	HandGame

Cheers

[Anonymous]

may be like this at script?

Load

AccNo,

FirstValue(ProductNo.) as ProductNo.,

FirstValue(ProductType) as ProductType,

Resident YourTable

group by

AccNo;

[sunny_talwar]

Or you can do this as well:

Table:

LOAD LineNo,

          AccNo,

          ProductNo.

          ProductType,

FROM Source;

Right Join (Table)

LOAD ProductType,

          Min(LineNo) as LineNo

Resident Table

Group By ProductType;

[Anonymous]

thanks but i actually want to do this in an expression within QlikView.  To break it up,  how can i do the following.  First in a seperate column,  i wan to add a query that reads if AccountNo. exists more than once  add 2, else add 0.

[sunny_talwar]

May be this:

If(Count([AccNo.]) > 1, 2, 0)

with [AccNo.] as your straight table's dimension

[Digvijay_Singh]

Try like this -

[#7]

Hi Laura

Please try this expression.

Table:

LOAD LineNo,

          AccNo,

          ProductNo.

          ProductType,

if(peek(AccNo)=AccNo,firstvalue(AccNo),AccNo) as AccountNO

FROM Source;

[#8 · Accepted solution]

Hi Laura,

You can try like this also..

[Anonymous]

thank-you. I just want to show a number separately on its own (i.e. in a separate box).  how can I do this please?

[Anonymous]

thank-you. I just want to show a number separately on its own (i.e. in a separate box).  how can I do this please?

E.g:-