topic Re: Dimension with case in QlikView

Dimension with case

amiroh81 — Wed, 04 Mar 2015 10:32:35 GMT

Hello all,

I want to built dimension with sum of expression.
For example:

i have table like this

Month number count

--------- --------- ----------

jan 22222 100

jan 22222 205

jan 33333 150

feb 22222 50

feb 33333 100

feb 33333 50

and i want to add dimension (type) that wiil show me - if(sum(count)>'300','big','small')

Month number count type

--------- --------- ---------- -------

jan 22222 305 big

jan 33333 150 small

feb 22222 50 small

feb 33333 150 small

if i add expression with this case i get blank field.

thanks in advaned

Amir

Re: Dimension with case

Gysbert_Wassenaar — Wed, 04 Mar 2015 10:36:59 GMT

Try =aggr(if(sum(count)>'300','big','small'),Month)

Re: Dimension with case

sunny_talwar — Wed, 04 Mar 2015 10:38:10 GMT

Try using it like this (without the single quotes)

=If(Sum(Count)>300,'big','small')

HTH

Best,

Re: Dimension with case

Wed, 04 Mar 2015 10:40:46 GMT

try the following as dimensions:

Aggr(If(Sum(Count) >= 300, 'BIG', 'Small') , Month)

Re: Dimension with case

Wed, 04 Mar 2015 10:41:08 GMT

Hi,

Can You use in script

TEST:

LOAD * INLINE [

Month,Number,Count

jan, 22222 , 100

jan , 22222 , 205

jan , 33333 , 150

feb , 22222 , 50

feb , 33333 , 100

feb , 33333 , 50

];

TEST2:

LOAD Month&Number&Sum(Count) as KEY,

Month,

Number

Resident TEST Group by

Month,Number;

DROP Table TEST;

Regards

Vimlesh

Re: Dimension with case

anbu1984 — Wed, 04 Mar 2015 10:41:56 GMT

Dim: Month,number

Expr: sum(count)

if(sum(count)>'300','big','small')

Re: Dimension with case

simenkg — Wed, 04 Mar 2015 10:54:10 GMT

Create a Straight Table with

Dimensions:

Month

Number

Expressions.

Sum(Count) // label the expression i.e: TotalCount

=if(TotalCount>300, 'Big', 'Small') // Reference the label of the above expression and test on it.

Re: Dimension with case

amiroh81 — Wed, 04 Mar 2015 12:01:46 GMT

Thank you all