topic Re: Calculated dimension for money in QlikView

Calculated dimension for money

madhuqliklondon — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Calculated dimension for money

Anonymous — Thu, 10 May 2018 12:10:45 GMT

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

Re: Calculated dimension for money

sasiparupudi1 — Thu, 10 May 2018 12:34:41 GMT

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

Re: Calculated dimension for money

Anonymous — Thu, 10 May 2018 14:30:05 GMT

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

Re: Calculated dimension for money

madhuqliklondon — Tue, 15 May 2018 10:45:18 GMT

Thank you all.