topic Straight table double dimension in QlikView

Straight table double dimension

Kunkulis — Sat, 16 Nov 2024 03:51:20 GMT

Hi,

I have a Straight table with 3 columns. 2 dimensions and 1 Expression.

The columns I have are the department, the manager and the sum

Problem is that in the qvd file I might have empty cells, which leads to having two or more departments, where in the manager column I will see the manager and below it I will see an empty cell.

I tried adding the manager column as an expression dimension if(manager='','',manager), but it didn't help.

Any idea how this could be solved?

Re: Straight table double dimension

albertovarela — Mon, 15 Apr 2019 18:08:19 GMT

What do you mean by empty cell? is that a blank, a space or a null? this might lead you to use if(IsNull(Manager)....

Can you post some sample data?

Re: Straight table double dimension

Kunkulis — Tue, 16 Apr 2019 06:47:15 GMT

I believe the cells are null/blank, because a formula if(Manager='','-',Manager) it does add the '-' in cells.

In the attachment I made a small version of the issue. Please keep in mind that the real issue is on a much bigger and more complex scale, the original app has tick boxes where you create the table, but the expressions are constant, so would be nice if the solution would come outside the expressions. Also in the big version there are multiple people columns which could be chosen and they also have null cells.

Re: Straight table double dimension

arpitkharkia — Tue, 16 Apr 2019 12:35:45 GMT

Assuming that for every department we have only one manager, i have created a file.

A left join is performed to get the manager names for blank values.

Re: Straight table double dimension

albertovarela — Tue, 16 Apr 2019 16:12:51 GMT

Based on the assumption that there is a 1:1 relationship between Department and Manager here is an alternative solution using the ApplyMap function.

Re: Straight table double dimension

Kunkulis — Wed, 17 Apr 2019 11:23:55 GMT

Thank you for your effort, but this solution won't do the trick.
Is there a solution that wouldn't involve changes to script, but rather work in the straight table.

Because, if there is an empty cell in the *.qvd than it has to be null.

Re: Straight table double dimension

Vengatesh — Wed, 17 Apr 2019 12:20:06 GMT

Add Manger as an Expression

Re: Straight table double dimension

arpitkharkia — Wed, 17 Apr 2019 12:27:53 GMT

If you know all the managers for each department you can use the following dimension

=if(Department='A','Bob',
if(Department='B','Ben'))