Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
uday_321
Contributor
Contributor

Unable to get Measures vs Measure working in straight or pivot table.

Dear Qlik Community Member, 

I've a requirement where I need to plot measures on rows and columns in the straight table. Tried with inline table to create field KPIs (rows) and if statement to add measures in a given row. But whenever I add a new measure it creates a separate row. I'd like to plot each value in the desired cell. E.g. Revenue for Y'day of two entities A and B should come separately as shown in screenshot. Haven't found any article on a similar line. Appreciate any leads on this issue. If you are aware of any extension that can do job then do let me know. 

 

Measure vs Measure Issue.PNG

 Regards, Yudi

1 Solution

Accepted Solutions
uday_321
Contributor
Contributor
Author

Thanks! Got it working with inline-table for measure names and nested condition at the front end. 

View solution in original post

2 Replies
Or
MVP
MVP

Not sure what these "measures" are. You could enable totals and use Dimensionality() to make the formulas for the totals behave differently from the ones in the lines, if that helps.

uday_321
Contributor
Contributor
Author

Thanks! Got it working with inline-table for measure names and nested condition at the front end.