topic Re: Re: Straight Chart Problems in QlikView

Straight Chart Problems

anuradhaa — Wed, 28 Aug 2013 10:16:32 GMT

Hi,

I have a problem and i couldn't find a solution for this. pls help me to solve it.

I have create a Straight Chart, and there i select the BEST TOTAL COST for all destinations. (destination have multiple values and i select the best one)

Total Cost = Freight Cost + Product Price.

In the chart i have display Freight cost and Product Cost associated with best Total COST.

So when i have multiple values for BEST TOTAL COST , the chart shows '-' in Freight , Product Cost.

But i want to display all available results for that minimum BEST TOTAL COST.

I have attached a xcl file also.

This is the expression i used in the Chart

=min({<OWNER_TO_LOC_FLAG={'Y'}>}TOTAL_COST)

=FirstSortedValue({<OWNER_TO_LOC_FLAG={'Y'}>}ORIGIN,TOTAL_COST)

and i use DESTINATION as Demenssion

Re: Straight Chart Problems

MayilVahanan — Wed, 28 Aug 2013 10:22:22 GMT

Try like this

= Aggr(min({<OWNER_TO_LOC_FLAG={'Y'}>}TOTAL_COST), [Best SUP A Origin],DESTINATION)

can you provide a sample file?

Hope that helps

Re: Re: Straight Chart Problems

anuradhaa — Wed, 28 Aug 2013 11:19:31 GMT

Hi pls chk attached QVW for more detail. Here you can see the Origns are missing.

Re: Straight Chart Problems

anuradhaa — Wed, 28 Aug 2013 11:20:21 GMT

See attached QVW