topic Re: urgent help need in QlikView

urgent help need

Wed, 12 Mar 2014 14:40:23 GMT

i m making the site column in my chart like this.

if(Left(location1,2)='V7','DSI',if(Left(location1,2)='V8','SML',if(location1='V956','non foot',if(location1='D12','67WS')))) as site

now i want to get Sum(saleQty) only to site fields. how can i use set analyse to this?

Re: urgent help need

srchilukoori — Wed, 12 Mar 2014 16:08:28 GMT

please post a sample app

Re: urgent help need

Wed, 12 Mar 2014 17:51:45 GMT

Use below in Dimension of Either straight or pivot table

if(Left(location1,2)='V7','DSI',if(Left(location1,2)='V8','SML',if(location1='V956','non foot',if(location1='D12','67WS')))) as site

and

in Expression just use

sum(SaleQty)

Like...

if(accpg_ordtyp='SL','Sale',if(accpg_ordtyp='CR','Credit')) - For Dimension

sum([Net Sales]) -For Expresion

Vinay

Re: urgent help need

chiru_thota — Wed, 12 Mar 2014 18:17:02 GMT

Can't you create Site dimension while loading data itself?

I mean by using your If statement.

It will be good if you can do that.So that you can use Site directly and it will be fast.

Otherwise you can follow as Vinay mentioned.

Re: urgent help need

Thu, 13 Mar 2014 01:50:03 GMT

hi all, yes i can get that like vinay has told. but the problem is another extra row loading in my table chart because of sum(saleQty) not related to "site". because there are other saleQty. so i want to avoid it and get only site's Sum(saleQty)

Re: urgent help need

chiru_thota — Thu, 13 Mar 2014 02:18:46 GMT

Enable following property for your dimension.