Adhoc reporting with QlikView, cyclic groups, order and subtotals issue

[#1]

Hello everybody,

there are so many concepts how to enable an Adhoc reporting in QlikView. In order to empower the end user it is necessary to allow him select whatever does he or she needs to.

I've created following example, where one thing I do not know is how to display a control field to enable switch the dimensions.

I still hope there is some hidden functionality which could do the trick.

1) A virtual cyclig group is beeing displayed, however just the first dimension and it is not possible to switch it. Do you know some trick how to achieve this?

2) Is there any possibility to activate and deactivate subtotals for specific fields from the end user perspective without going into menu? (User could be irritated and confused from the formulas).

3) If drag and drop is activated, user can change the order of characteristics. When Pivot table is activated, some fields behave strage - display in the header/columns or they are hidden on position where user don't expect them. (behind, 5th position instead of 2nd). Do you know how to reorder / sort characteristics as user wants to see them?

4) Does anyone of you have any idea, how to change dynamically my timeline in this example to switch/activate and deactivate some time columns?

If you have any questions, do not hasitate to contact me.

Thank you very much in advace

Regards

Stan

[#2]

Is there a possibility to display all members of a cyclic group?

like GetCurrentField(MyCyclicGroup) -> get all fields as a list ?

maybe some trick like: {$< $(=Concat( distinct '[' & _FieldList & ']=[S1]::[' & _FieldList & ']',',' )) >}   ???

[amars]

See attached file. Look for the "Enable Condition" Property inside your Chart Properties -> Dimensions tab.

Thanks...

[#4]

Michael,

this is nice, of course. The issue is, I'm trying to implement a variable definition of an adhoc reporting. Here, in your scenario a cyclic group has to be added into a table.

Now imagine, if there would be a possibility to define just variable fields and those fields fill from the selected dimension list, how much work would this save. Example from our company - you have more than 100 characteristics to choose from in the dimension list. Some of them could be fixed fields and some of them cyclic groups. This will mean really much manually effort. If the field variable would be able to pick a cyclic or a field then nobody has to care which type of field has been chosen.

Therefore my question if it is possible to list all members of a cyclic group in order to switch them easily (as subfields of a main field-cyclic group).

I'll post my variable approach, hopefully community will be able to improve it.

Stan

[amars]

Not sure still, please check the attached file. But it won't work properly for the Group as the group representation is different.

Also only one dimension can be selected at a time.

Thanks...

[#6]

I've prepared a version comparing what I'm trying to achieve WITHOUT tricks and macros. Not sure if this will be possible without additional help from QlikTech - to implement some stuff as a standard.

Our stuff (users) loves reporting in tables. They do not have any knowledge or privileges to display and modify properties of tables in the portal.

They urgent need following things to do:

- define for the key figures how many decimals should it have (0 or 0,0 or 0,00)

- activate and deactivate subtotals for any chosen characteristics (or more of them)

I do have issues with subtotals. Please have a look at the attached qvw file 00template. Let me know if you do know some trick how to deal with cyclic groups - to display them and let the user interact with the cyclic group. (without a implemented work around)

Independent from this task I need a solution to identify which characteristics are active and just only for them activate or deactivate subtotals (in a pivot and straight table version).

Let me know if you have any better ideas, questions or another improvements.

Thank you very much

Stan