Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
EliAttiaQlik
Contributor II

switch between a pivot table and a straight table

Is there any possibility to allow a user to switch between a pivot table and a straight table  using the same object like we had in qlikView

 

Labels (2)
4 Replies
SunilChauhan
Champion II

Not Exactly you can try

Use container and have both straight and Pivot . Switch b/w table on click .

Sunil Chauhan
EliAttiaQlik
Contributor II
Author

yes, i agree but I wanted to avoid writing the dimension and metrics twice.

For every change the user requests I have to remember to correct in two places or use variables.

It's a shame hat qlik didn't give this functionality  in sense.

SunilChauhan
Champion II

May be try some Extensions. But origin and inbuild thing are always better. Here we dont have option i belive so give a try .

Sunil Chauhan
Lech_Miszkiewicz
Partner Ambassador/MVP

Hi @EliAttiaQlik why writing it twice?

You just create straight table as you need, then copy it and drag and drop and convert pivot to pivot table - it takes seconds. Then use in container.

For maintantnace - you use master items or variables- thats exactly what they are for at the end.

Lech_Miszkiewicz_0-1715837409358.gif

 

and yes - I know it is not the same as fast change, but is is not that bad.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.