topic Set Anlysis for Dimension in QlikView

Set Anlysis for Dimension

james — Mon, 05 Mar 2012 23:01:30 GMT

Anyone have any luck using set analysis to derive a toggle? My situation is my Revenue total is derived from 4 sets of set anlsysis, yet I want the Dimension in a staright table to be smart ebnought to know that the First line should say gadgtes, the 2nd Line to say Widgets, the 3rd line to say Bolts and the 4th lione to say Nuts.

Any ideas?

Re: Set Anlysis for Dimension

Mon, 05 Mar 2012 23:19:29 GMT

Not sure if I have correctly understood what you are trying to achieve but it sounds like you are trying to create a chart with a detatched dimension set. See if the attached is what you are trying to do.

Re: Set Anlysis for Dimension

james — Mon, 05 Mar 2012 23:22:13 GMT

Matt- the issue is Dim1 should be based on like if(Color = 'Yellow', Gadgets,if(Fad = 'Old', Widgets))

Yet you cannot do an if than using 2 diff data sets.

So i was hoping i could use set analysis to give me the names

Set Anlysis for Dimension

Anonymous — Mon, 05 Mar 2012 23:45:09 GMT

Matt,

a nice bit of code using data islands.

James, do you have an example to post?

Re: Set Anlysis for Dimension

Mon, 05 Mar 2012 23:55:44 GMT

I've obviously not understood what you are trying to achieve. Can you explain in some more detail?