Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
madhuqliklondon
Creator II
Creator 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
Anonymous
Not applicable

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
Anonymous
Not applicable

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')

sasiparupudi1
Master III
Master III

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

Anonymous
Not applicable

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

madhuqliklondon
Creator II
Creator II
Author

Thank you all.