topic Re: expression for the following scenario in QlikView

expression for the following scenario

Fri, 13 Dec 2013 19:00:54 GMT

I need to get the same supplier group for the common Global supplier id

Gloabal supplier id , ncr, scar, partnumber , supplier group

ew-000891 234 145 ahaas652 CMDS

ew-000891 12 3 fa -

ew-000891 - - - -

Please find screen shot.

For that same global supplier id i need to CMDS as supplier group for the remaining two records

Re: expression for the following scenario

Anonymous — Fri, 13 Dec 2013 19:32:14 GMT

How about first doing a mapping load :

SupplierGroupMap :

Mapping Load distinct

[Gloabal supplier id] ,

[supplier group]

from ............ your datasource

;

Then when you load your real data something like :

Load

ApplyMap ( 'SupplierGroupMap' , [Gloabal supplier id] ) as [Supplier Group from AppyMap] ,

from ............ your datasource

;

Best Regards, Bill

Re: expression for the following scenario

Fri, 13 Dec 2013 19:36:17 GMT

Need to do on UI

Re: expression for the following scenario

Anonymous — Fri, 13 Dec 2013 19:39:45 GMT

Why ?

Re: expression for the following scenario

Fri, 13 Dec 2013 19:50:26 GMT

I cant change the script now i can only have expression for that..

Thanks in advance

Re: expression for the following scenario

Colin-Albert — Fri, 13 Dec 2013 20:15:52 GMT

Bill's answer is correct. Don't try and fix an incorrect data model by bodging the chart. Get the correct data model and the chart is simple.

Re: expression for the following scenario

maxgro — Fri, 13 Dec 2013 20:38:17 GMT

try this

MaxString(TOTAL <[Gloabal supplier id]> [supplier group])

Re: expression for the following scenario

Anonymous — Fri, 13 Dec 2013 21:34:09 GMT

write a calculated dimension instead,

= if(Global supplier id= 'ew-000891', 'CMDS', ' ' )

Re: expression for the following scenario

Fri, 13 Dec 2013 22:55:09 GMT

thanks, i have many global supplier id's .That's the issue

Re: expression for the following scenario

preminqlik — Sat, 14 Dec 2013 04:34:56 GMT

here u go :

MaxString(TOTAL <[Gloabal supplier id]> [supplier group])

Re: expression for the following scenario

Sat, 14 Dec 2013 16:20:27 GMT

Whilst it may be possible to work around this problem in the UI objects, I agree with some of the earlier posts that this should be fixed in the load script. Using the extra functions on the UI will likely impact performance and when you reach a critical volume of data this may make you app unusable.

Re: expression for the following scenario

qlikpahadi07 — Sun, 15 Dec 2013 06:06:11 GMT

Hi Sreddy,

I think maxgrohad provided you the solution ? isit ?