Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Conditional expression result calculation

I have a pivot table that is set up like this:

amount 1          amount 2          %

1699.53               323.53          Column2/column1 or 19%

I need help with an expression that says if column 3 is 60%> or larger then i want 2% of column 2.  If it is 51-60% then i want 1.5%.  if it is 45-50% then i want 1%. 

Any suggestions?  I am befuzzled on this one.

Thanks,

Kristy

1 Solution

Accepted Solutions
MVP
MVP

Re: Conditional expression result calculation

Maybe like

=column(2) * if(column(2)/column(1) > 0.6, 0.02,

                         if(column(2)/column(1) > 0.51, 0.015,

                              if(column(2)/column(1) > 0.45, 0.01)))

edit, since you already got column(2)/column(1) as column(3):

=column(2) * if(column(3) > 0.6, 0.02,

                         if(column(3) > 0.51, 0.015,

                              if(column(3) > 0.45, 0.01)))

1 Reply
MVP
MVP

Re: Conditional expression result calculation

Maybe like

=column(2) * if(column(2)/column(1) > 0.6, 0.02,

                         if(column(2)/column(1) > 0.51, 0.015,

                              if(column(2)/column(1) > 0.45, 0.01)))

edit, since you already got column(2)/column(1) as column(3):

=column(2) * if(column(3) > 0.6, 0.02,

                         if(column(3) > 0.51, 0.015,

                              if(column(3) > 0.45, 0.01)))