topic Re: Set Identifier - Quick Question? in QlikView

Set Identifier - Quick Question?

Wed, 19 Aug 2015 15:33:20 GMT

I'm creating a pivot table that will have Item Categories and Items along the side, and Warehouse Locations across the top. I want to show a sum of sales in the table. The Item Categories and Items along the side should respond to filter selections, but the Warehouse Locations across the top should stay static -- i.e. always show all locations, even if the user has one or more selected.

I've tried a number of things with the set identifier, but don't see a way to call out a specific field. I'd rather not use a bookmark. I feel like I'm missing something. Can someone help? Thanks.

Re: Set Identifier - Quick Question?

Wed, 19 Aug 2015 15:36:53 GMT

You need to use TOTAL qualifier to avoid the Warehouse filters

SUM(TOTAL <Item_Category , Item_Name> SALES)

Re: Set Identifier - Quick Question?

Wed, 19 Aug 2015 15:51:40 GMT

Thanks. That doesn't work. The Locations still respond to the filter.

Re: Set Identifier - Quick Question?

sunny_talwar — Wed, 19 Aug 2015 15:55:39 GMT

May be this:

{<[Warehouse Location] = >}

Re: Set Identifier - Quick Question?

julian_rodriguez — Wed, 19 Aug 2015 15:55:57 GMT

Hello

Try SUM({$<[Warehouse Locations] = >} Sales)

This expression will ignore the selections on the field "Warehouse Locations"

Regards

Re: Set Identifier - Quick Question?

maxgro — Wed, 19 Aug 2015 15:59:54 GMT

try

sum({$ <[Warehouse Locations]= >} sales)

Re: Set Identifier - Quick Question?

jagan — Wed, 19 Aug 2015 16:08:46 GMT

Hi Brian,

Try like this in Set Analysis

Sum({<WarehouseLocation=>} Sales)

WarehouseLocation= will ignore the selections in WarehouseLocation field.

Note: WarehouseLocation and Sales with your actual field name.

Regards,

Jagan.

Re: Set Identifier - Quick Question?

Wed, 19 Aug 2015 18:41:53 GMT

That seems to work. I swear I tried it and it did not. Thanks everyone.

Re: Set Identifier - Quick Question?

jagan — Wed, 19 Aug 2015 23:56:00 GMT

Hi Brian,

If you got the answer please close this thread by giving Correct and Helpful answers so that it helps others in finding the answers easily.

Regards,

Jagan.

Re: Set Identifier - Quick Question?

Anonymous — Thu, 20 Aug 2015 01:10:46 GMT

Try this: Sum({$<WarehouseLocation=>} Sales)

Re: Set Identifier - Quick Question?

mohammadkhatimi — Thu, 20 Aug 2015 04:02:12 GMT

Hi Brian,

Try this in Set Analysis

Sum({<WarehouseLocation=>} Sales)

Hope this will Helps you...!!

Regards,

Mohammad