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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-08-12 09:31 AM

Dimension + calculated value

Hello all,

I have two date fields. One is registration year and second is bill year. I also counted unique serialno under each year as you see in

the picture bellow.

Then I created pivot table which contains bouth data fields and one expression where I count how many workorder I have under each year.

My quastion is: Is it possible to somehow show YearFREGD and YearBILLD together with figures from previous expressions?

For example: YearFREGD => 2007(707), YearBILLD => 2006(28), 2007(610), 2008(577), 2009(476), 2010(428), 2011(394), 2012(369)

and 2013(301)

1.PNG

The new table should look like this:

               2006(28)  2007(610)  2008(577)  2009(476)  2010(428)  2011(394)  2012(369)  2013(301)

2007(707)     63          3007        3430         1920          1647          1532         1414          856

Thanks

234 Views
0 Likes
0 Replies