Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to make my result display 688,750 ?

Hi All

I unable to figure out how to modify the expression to make it display the right value i need. Hope some one can advise me.

Paul

3 Replies
Not applicable

Re: How to make my result display 688,750 ?

Hi All

Enclosed my QV doc. My question post on QV doc.

Paul

MVP
MVP

Re: How to make my result display 688,750 ?

Paul,

your expression uses completely different fields and calculations based on your selections:

if(match(Currency_P,'SG'),

money(

(

Ceil(

LAND_COST_TDS_SGD

,0.5)

)

,CurrencyFormat_P),

money(

(

Ceil(

FOB_SGD_SUB*RATE_P/LESS

,0.5)

)

,CurrencyFormat_P)

)

so without knowing the logic you want to apply here for your rate conversions, the data model and your overall requirements, it's very hard to give you any advice.

Not applicable

Re: How to make my result display 688,750 ?

Hi swuehl

Nice to see you reply to my post, i still remember you hv solve my P&L issue.

You completely correct right. i need to go back to basic and start to create the expression to get what i want. no short cut.

Thank

Paul

Community Browser