Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Calculated dimension for money

Hi I am trying to write calculated expression , I have "if (TotalGBPExlVAT>=35, 'Over 35')" , what I am trying now is £35.01 to £39.99  and name  as from 35.01 to 39,99. how do I write this. 

1 Solution

Accepted Solutions
Highlighted
Contributor

Re: Calculated dimension for money

Hi,

When I did something similar I used a nested if statement i.e.


if (TotalGBPExlVAT>=35, if (TotalGBPExlVAT<=39.99, 'from 35.01 to 39,99', 'Over 35')

View solution in original post

4 Replies
Highlighted
Contributor

Re: Calculated dimension for money

Hi,

When I did something similar I used a nested if statement i.e.


if (TotalGBPExlVAT>=35, if (TotalGBPExlVAT<=39.99, 'from 35.01 to 39,99', 'Over 35')

View solution in original post

Highlighted
Honored Contributor III

Re: Calculated dimension for money

if (TotalGBPExlVAT>=35 and TotalGBPExlVAT<=39.99, 'from 35.01 to 39,99','Over 40')

Partner
Partner

Re: Calculated dimension for money

Hi

write the script for  bucketing in back end to calculate Money dimension use that dimension in front end

=if (TotalGBPExlVAT>=35, 'Over 35',if(TotalGBPExlVAT>=35.01 and TotalGBPExlVAT<=39.99,'from 35.01 to 39,99')) as Money

Highlighted
Contributor II

Re: Calculated dimension for money

Thank you all.