Detached object does not remain detached; have to re-attach after reload and upon opening document

[bullish35]

I am using images to present year-over-year trend data at a glance. I want the arrow under 'Division' to always reflect the division's trend overall and the arrow under 'Channel' to change based on selected channel data. The purpose is so that a channel head drilling down into their own data sees their performance relative to the Division as a whole - without having to reselect all data.

When I 'detach' the object for Division, this works perfectly. However, every time I reload data or re-open the file in QlikView, all objects are attached again. Will this behavior change once the document is published, or am missing something in the configuration at the document or object level? The arrow objects are charts, configured as a straight table, where the expression is represented by an image.

[pover]

You just use

count({1} MaterialNumber)

or

count({$<Field1=,Field2=,Field3=>} MaterialNumber)

Regards.

[#3]

Hi All,

I have made a pivot table for dispalying calendar according to quarters of last 2 years. I have used following expression for the same:-

actual_year_nbr & '-' & actual_mth_nbr

Getting calendar properly but now I need to detach it in my file so that it wont change as per parameters given. Kindly suggest how can I use above given solution for this. I tried:-

({1}actual_year_nbr) & '-' & ({1}actual_mth_nbr)

But its not working. Please help.

Thanks,

Kirti

[#4]

I have done it.

Used

minstring({1} actual_year_nbr & '-' & actual_mth_nbr) and this is working now.

Thanks a lot.

Regards,

Kirti