topic Field on a individual drill down level. in QlikView

Field on a individual drill down level.

Tue, 15 Sep 2009 23:35:00 GMT

Hi,

I have a drill down group where I can drill down from department to each individual product, I would like to be able to show the pack size just on the product level. I have done the following but the result looks rather messy, is there a simple way of achieving this ?

=[Product] & ' ' & [Pack]

Thanks,

Gavin.

Field on a individual drill down level.

stephencredmond — Tue, 15 Sep 2009 23:40:36 GMT

Does it look better like this?:

=[Product] & ' (' & [Pack] & ')'

Stephen

Field on a individual drill down level.

Wed, 16 Sep 2009 00:08:55 GMT

Yes it does look better, although I was hopint to be able to insert a column for exporting to excell.

Field on a individual drill down level.

johnw — Thu, 17 Sep 2009 00:43:51 GMT

If I understood the question, I can think of a couple of approaches.

First, you could have two charts, one with the Pack column, one without. Use a show condition that depends on the value selected for the drill down group, like getcurrentfield(MyGroup)='Product'. That might be nicest from a presentation point of view, but would require dual maintenance.

Second, have one chart with the Pack column, and use a condition in the expression to only return a value if you're at the Product level in the drill down group, like if(getcurrentfield(MyGroup)='Product',sum([Pack])).

Field on a individual drill down level.

Wed, 07 Oct 2009 18:22:36 GMT

Thanks John,

Works fine.