how to create a totalled pivot/straight table - Qlik Community

Report Inappropriate Content · ‎2016-02-12

I wanna create this type of table in straight and pivot table. See attached full table.

Note: I don't need more fields added to the 4 fields

kaushiknsolanki · ‎2016-02-12

Hi,

You can use the pivot table to achieve this, but you will have to group the classes so that qlikview can club then on the basis of group and give you the total at group level.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Anonymous · ‎2016-02-12

In

Presentation Tab Have Condition To give the condition in the column which fields you are required that only comes and others are come

Anonymous · ‎2016-02-12

Did you face any issue while creating this in QV?

Anonymous · ‎2016-02-12

Ya

I have lot of Data i want hide the some of the columns and i do it. In this way you do it

Report Inappropriate Content · ‎2016-02-12

Yes

its_anandrjs · ‎2016-02-12

Can you share your QVW file here to have a look.

Regards

Anand

Report Inappropriate Content · ‎2016-02-12

I don't need a fifth field

kaushiknsolanki · ‎2016-02-12

You Can hide the test of that field, So for end user they wont see 5th Field.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2016-02-12

The issue is I wanna choose where to place my TOTAL on the table not the table using the default way