topic Re: Table with Total Function Columns in QlikView

Table with Total Function Columns

Fri, 30 May 2014 16:29:26 GMT

Hi,

I'm creating a table something like this:

"Product"

"Region"

"Product Region Sales" ------------------------ sum(Sales)

"All Product Region Sales" ------------------- sum(total<Region>{<Product>}Sales)

"Product National Sales" ---------------------- sum(total<Product>Sales)

"All Product Region Sales" ------------------- sum(total{<Product=>}Sales)

The values are OK, but when I select a Product, I want the lines from the other products to disapear because the "Product Region Sales" and "Product National Sales" are equal to 0.

What should I do?

Thanks in advance,

Francisco.

Re: Table with Total Function Columns

PrashantSangle — Fri, 30 May 2014 16:39:36 GMT

Hi,

I am not sure what you want but as per my understanding,

You don't want to show "Product Region Sales" and "Product National Sales" if Product is selected

then,

You Can try Conditional Column.

Write

If(getSelectedCount(Product)<1) for those column.

Regards,

Re: Table with Total Function Columns

Fri, 30 May 2014 16:57:51 GMT

Imagine I have Product A and B, with no selection table is OK, but the problem is when I select Product A this happens this:

The problem is when I select Product A this happens this:

Product Region Sales Regional Market National Sales National Market Sales

A 1 10 50 200 1000

A 2 5 10 75 1000

B 1 0 50 0 1000

B 2 0 10 0 1000

Because I select product A, the Sales (Regional and National) of product B are 0 and I don´t want the lines from Product B appear on the table.

Was I clear?

Thanks,

Re: Table with Total Function Columns

Fri, 30 May 2014 17:59:42 GMT

What kind of table are you using? A pivot table should do that for you

Re: Table with Total Function Columns

Fri, 30 May 2014 20:51:21 GMT

Thanks Robert for your post...

I resolved my problem with Dimension Limits.

Regards,