havivdanny wrote: I need somting that will make this very easy. I reapet ,The person that using pivot table in excel is doing it very simple... <div></div>
It's also very simple to do this in QlikView - all you have to do is use the Inline Load in your script to set the categories. This is exactly the same thing your Excel user is doing - manually assigning a new dimension to each old dimension value. Unfortunately, this has to be done via script, not via chart manipulation.