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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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