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

Announcements
Join us in Toronto Sept 9th 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