Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cell calculation in a table

Hi folks,

could somebody take a short look at the attached file and tell me if it is possible to calculate each cell like i can do it in Excel?

My problem is that I can do it only per column and not for each cell. But i.e. for May I need # of logged and # of closed in one column...

I would be thankful for a short description!

Thanks!

1 Reply
swuehl
MVP
MVP

Dave, I am unsure what your requirements are looking at your attached file.

Your data model contains no fact data, this might also support my confusion.

Can you post the excel file, too, so we can see what you are trying to achieve?

In general, you can't use a table box for calculations (i.e. using expressions). You'll need to use a chart (pivot, straight table, or one of the graphic charts).

You can then look into the inter chart record functions (above(), below(), before(),top() etc.), these might help you in doing what you want (well, I honestly don't know what you want, see above).

Regards,

Stefan