Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

How to add condition For IDR currency < 300 don't round otherwise round up 0.5

Hi All

Below expression work fine , it only round up 0.5 when value more then 10.

  if ( column(1) <10 ,

  num( ( column(1)) , '#.##')  ,

  num( Ceil(  column(1),0.5) , '#.#') )

Now i like to add one more condition , if user select :-

Currency_P=SG value < 10 don't round other wise round up to 0.5

Currency_P=INDO value < 300 don't round other wise round up to 0.5

I assume the expression should be as following :-

if Currency_P='SG',

  if ( column(1) <10 ,

  num( ( column(1)) , '#.##')  ,

  num( Ceil(  column(1),0.5) , '#.#') )

if Currency_P='INDO',

  if ( column(1) <300 ,

  num( ( column(1)) , '#.##')  ,

  num( Ceil(  column(1),0.5) , '#.#') )

))

But it does not work . Hope some one can advise me.

Paul

1 Reply
paulyeo11
Valued Contributor II

Re: How to add condition For IDR currency < 300 don't round otherwise round up 0.5

enclosed my QV doc

Community Browser