topic Re: How to keep different Top 'N' values in same line? in QlikView

How to keep different Top 'N' values in same line?

Thu, 27 Apr 2017 07:53:50 GMT

I have a Table with Sales Data..

Customer, Material_Type, Material and Volumes.
I'm trying to build a table where I need to show, for each customer and Material Type.. Top 'N' Materials.. in the example N=2

I need to put Material_Types in the same line..

How can I limit materials in different columns?

thanks

Andrea

Re: How to keep different Top 'N' values in same line?

antoniotiman — Thu, 27 Apr 2017 08:46:31 GMT

Hi Andrea

Dimensions :

Customer

=Aggr(If(Rank(Sum(Volume)) <= 2,Material),Cust,MatType,Material)

Material

Expression :

Sum(Volume)

See Attachment

Regards,

Antonio

Re: How to keep different Top 'N' values in same line?

Thu, 27 Apr 2017 08:53:57 GMT

Hi Antonio

thanks a lot for your answer..

This is something close to solution, but what I've been requested to do is to display materials on same row...

Your proposal is definitely good and it would be a vaild alternative..

Do you think it's feasible to show on same line?

I wan thinking about entering Material as Expression but then no clue about how to proceed..

thanks

Andrea

Re: How to keep different Top 'N' values in same line?

antoniotiman — Thu, 27 Apr 2017 09:20:01 GMT

I think You need Material as Dimension because

CustA -> B2 and B4

CustB -> B1 and B2

Regards,

Antonio