Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
burgersurfer
Contributor III
Contributor III

Getting results into the same line

Hi, I am using set analysis to produce a table, wherein we want to compare transactions for this year, with the same period last year. My current model does not allow me to show them next to each other - I am only able to show this year's figure in one line, and the previous year below it.

How can I get the results aligned?

Attached is a screenshot of the table extracted to Excel, I need the green cells to line up in QV?

Capture.JPG

Thanks so much!

Corne

2 Replies
sunny_talwar

May be try using Inter-Record Functions to bring them on the same line. You might need Above/Below based on your sorting.

vamsee
Specialist
Specialist

You are classifying your data twice. Remove either your dimensions which are specific to a year like UPT 2019 or use one expression for both the year's.