switch between a pivot table and a straight table

[EliAttiaQlik]

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

[SunilChauhan]

Not Exactly you can try

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

[EliAttiaQlik]

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]

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

[Lech_Miszkiewicz]

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.

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