Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

straight table- expression written for a rowno

i have a straight table in which I have made 'horizontal' under presentation tab. so for eg

1. quarter is my dimension

2. sales and rebate in my expressions

I get months in columns and other metrics in first column as shown in table.

I want a last column which gives (quarter3-quarter2) value. for this i used rowno concept and wrote in condition two expressions.

I am not getting values in last column. strange thing is for some metrics im getting n for some i dont.

Please help with this. Thanks

Quarter1Quarter2Quarter 3
Netsales34455678234
Rebate337656
2 Replies
Not applicable
Author

Hi,

Please can you little more clear on your question or attach sample app of your task.

Regards,

Venkat

Not applicable
Author

This is my straight table which i have made horizontal.

I want the subtract of 3rd and 1st column in the last column. for this i tried with rowno concept but its not working