Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Merge Pivot tables together

I attached the tables i have:

-First how can i get the Percentage in table 3 as 647/ (647+589) and so on.

-Second i need to merge the tables together in order  TABLE 1 - TABLE 2 - TABLE 3 so i get the table as follow

Waiting Time

Visit Type

  1. Freq.

Percentage%

  1. Freq.

Percentage%

Visit Type

  1. Freq.

Percentage%

<30m

Yes

20

13%

50

32%

Yes

20

40%

No

30

19%

No

30

60%

31-60m

Yes

10

6%

43

27%

Yes

10

23%

No

33

21%

No

33

77%

1-2h

Yes

2

1%

47

30%

Yes

2

4%

No

45

28%

No

45

96%

>2h

Yes

12

8%

18

11%

Yes

12

67%

No

6

4%

No

6

33%

THANKS A LOT

2 Replies
MK_QSL
MVP
MVP

If you could upload your sample file, will definitely try to help you.

Not applicable
Author

sorry i cannot share the dash as it is confidential data. I guess the data presented to you us enough.

Especially for the formula part