topic Re: Condition on caluclation in QlikView

Condition on caluclation

qlikviewaf — Wed, 03 Jan 2018 13:24:42 GMT

Hi Guys,

i have two date for each sales-row on my data set.

First date is MonthYearInvoice the second date is MonthYearService.

i would like to calculate the % as follow:

Sales (Where MonthYearInvoice>MonthYearService) / Sales (without any condition)

i did it as follow but the result is 0

if(MonthYearInvoice>MonthYearService,sum(Sales),0) / Sum(Sales)

Anyone has an idea how to fix this?

Thanks

vishsaggi — Wed, 03 Jan 2018 13:30:36 GMT

Are the two data field formats same or different? May be you can use set analysis like

= Sum({< MonthYearInvoice = {"> MonthYearService"} >} Sales)/Sum(Total Sales)

= Sum({< MonthYearInvoice = {"= $(= '>'&MonthYearService)"} >} Sales)/Sum(Total Sales)

YoussefBelloum — Wed, 03 Jan 2018 13:34:28 GMT

Hi,

what is the format of your fields (MonthYearInvoice and MonthYearService) ?

pradosh_thakur — Wed, 03 Jan 2018 13:38:36 GMT

try this

= Sum({< MonthYearInvoice = {"=(num(MonthYearInvoice) > num(MonthYearService))"} >} Sales)/Sum(Total Sales)