topic Re: Calculated Dimensions in QlikView

Calculated Dimensions

Wed, 05 Feb 2014 06:43:46 GMT

Hi All,

Can some on please tell me how can i add calulated dimension matching mltiple criteria?

For example show all cities whr cd =1, 2,3

I tried this but it will not work because it will concatenate all the matching values CONCAT(DISTINCT {<cd={1,2,3}>} City,',')

Re: Calculated Dimensions

Wed, 05 Feb 2014 06:48:56 GMT

Hi Sunny,

Try this .if(Match(cd,1,2,3), City)

Thank you

Vardhan

Re: Calculated Dimensions

preminqlik — Wed, 05 Feb 2014 06:50:48 GMT

try this ------In dimension :

if(Cd=1 or Cd=2 or Cd=3 ,City)

Re: Calculated Dimensions

senpradip007 — Wed, 05 Feb 2014 06:50:51 GMT

try this:

if( cd < 4, City)

Re: Calculated Dimensions

Wed, 05 Feb 2014 06:53:04 GMT

Hi Pradip/Prem,

Sorry i forget to add that numbers will not be in order and they are not fix . It can also be text
Thanks

Re: Calculated Dimensions

rsdhavle — Wed, 05 Feb 2014 06:54:44 GMT

( Match(Cd, '1', '2', '3'), DISTINCT City)

Try this

Re: Calculated Dimensions

Wed, 05 Feb 2014 06:54:56 GMT

PFA...Hope this will helps you

Regards

Nirmal

Re: Calculated Dimensions

Wed, 05 Feb 2014 06:57:30 GMT

can you attach some sample

Re: Calculated Dimensions

Thu, 06 Feb 2014 07:14:50 GMT

Hi All

Please find the sample file attached.

What i am trying to do is as soon as i click on city Delhi in next chart it should show all sp who's id matches with city's id. For example for Delhi id is 1 ,2 , 4 so I want all sp and count with id 1,2,4 in second chart

Re: Re: Calculated Dimensions

tresB — Thu, 06 Feb 2014 08:36:52 GMT

Not sure if understood right. May be you just need to take ID/sp as dimension, like in attached sample. PFA

Re: Calculated Dimensions

er_mohit — Thu, 06 Feb 2014 09:42:32 GMT

See the attached file

hope it helps you either click on chart or list box you got the 2nd chart

hope it helps