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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sonikajain
Partner - Contributor
Partner - Contributor

table implementation

Dear all,

I am stuck in a scenario where I have to create table looking like the one below-

On the horizontal axis, I need to display quarterly divisions as well as Actual results, Trens etc, as in figure below.

Please suggest any implementation ideas.


Actual ResultsTrendActualYTD
XPY-Q1PY-Q2PY-Q3PY-Q4CY-Q1CY-Q2CY-Q3CY-Q4Q1-CY/PYQ2-CY/PYQ3-CY/PYQ4-CY/PYCY/PY12 Month12 Month12 MonthYTD PYYTD CYYTD Change
actualactualactual
endingendingchange
PYCY
A$1,692






-7.60%-6.40%1.30%1.60%-3.00%


$1,619

B$2,477






-7.60%-5.00%3.00%1.50%-2.30%


$2,394

C$908






6.90%1.30%1.70%7.00%4.10%


$924

D$1,002






8.70%0.60%0.50%-3.10%1.80%


$1,057

E$401






1.80%4.20%6.30%-3.30%2.40%


$392

F$1,476






20.80%20.40%21.10%-5.40%14.60%


$1,503

0 Replies