ABC analysis & letting user to sort straight table... - Qlik Community

Permalink · ‎2014-03-02

Hello.

Is there any method of making ABC in QlikView and still allowing user to sort the chart as he likes? For example, we are making ABC by sum(Sales), but user wants to view the data sorted by item name.

PrashantSangle · ‎2014-03-02

Hi,

You can achieve this by checking allowing interactive sort in sort tab

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Permalink · ‎2014-03-02

Well, that breaks ABC. As soon as user uses interactive sort, ABC analysis is done using his chosen field, not my Sum(Sales).

PrashantSangle · ‎2014-03-02

Hi,

well That is true because you can not make two column sort at same time,

so if possible try to give user some alternate option.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Permalink · ‎2014-03-02

Which one? This is also the problem of cross-ABC, for example. How do I make ABC analysis by two facts at the same time in one straight table?

ABC analysis & letting user to sort straight table as he likes?