topic Re: Cell-based detach in QlikView

Cell-based detach

Wed, 09 Oct 2013 12:07:49 GMT

Hi,

Do you know if it is possible to detach/attach specific cells of a pivot or straight table?

For example, let's say we have a pivot with rows the products and columns the months. Values are sales.

Product	Jan	Feb	Mar	Apr	Total
Product A	100	50	40	10	200
Product B	50	100	0	0	150
Product C	100	100	60	20	280
Product D	30	30	30	30	120
Product E	40	30	40	30	140
Product F	50	50	50	60	210

Could I select ad hoc to freeze (=detach) the values of Product C and D for months Feb and Mar (having of course the ability to change the selection)?

Thanking you in advance,

Greg

Re: Cell-based detach

CELAMBARASAN — Wed, 09 Oct 2013 12:19:18 GMT

There is no possibility to freeze some cells but you can somehow control with expressions.

Something like

Sum({<Product={'Product C', 'Product D'}, Month={'Feb', 'Mar'}>+$} Sales)

Re: Cell-based detach

Wed, 09 Oct 2013 12:28:00 GMT

Thank you,

I can definetely can use set analysis but it would not be "ad hoc".

However, I agree that I can somehow threat this as such. If I do this, do you know how I could dynamically highlight differently the cells that are frozen?

Thanking you again,

Greg

Re: Cell-based detach

CELAMBARASAN — Wed, 09 Oct 2013 13:26:40 GMT

You can set background color for expression like

If(Match(Product, 'Product C', 'Product D') AND Match(Month, 'Feb', 'Mar'), Blue(55), White())