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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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