topic USe set analysis to restrict data not using Sum in QlikView

USe set analysis to restrict data not using Sum

james — Sat, 11 Jul 2009 10:48:43 GMT

All, i am trying to get a set analysis to work so i can have a column restricted for a group, lets call it NOrth America.

I am trying to basically state if(data ="200, 300 , 400",'North America')

Basically I am tryng to forc in a grouping for 200,300 or 400 to be called North America

Any ideas? I cannot seemt o get set analysis to work outside of sums

USe set analysis to restrict data not using Sum

stephencredmond — Sun, 12 Jul 2009 00:54:55 GMT

Hi,

If I have to use a set on a field that is not part of a Sum/Count (e.g. a single value), I will generally use something like Max or MaxString so as to give me the option to include the set.

I have to ask though. Wouldn't it be easier, and more efficient for the calculation of your charts, to create these values in the script using a mapping?

Regards,

Stephen