How to merge 2 flag condition in same expression.

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

Currently I have a following syntax for the following image:

If(Flag1=1,if (Match([Actual_Fuel_Type],'HSFO'), sum( total {$<Actual_Fuel_Type={'HSFO'}>} If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, FUEL_MASS_BEFORE_SOUNDING)/ 1000),

if (Match([Actual_Fuel_Type],'LSDO'), sum( total {$<Actual_Fuel_Type={'LSDO'}>}If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, FUEL_MASS_BEFORE_SOUNDING)/ 1000),

if (Match([Actual_Fuel_Type],'HSDO'), sum( total {$<Actual_Fuel_Type={'HSDO'}>}If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, FUEL_MASS_BEFORE_SOUNDING)/ 1000),

if (Match([Actual_Fuel_Type],'ULSFO'),sum( total {$<Actual_Fuel_Type={'ULSFO'}>}If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, FUEL_MASS_BEFORE_SOUNDING)/ 1000),'Unknown'

)))))

where Flag=1 is given by

If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, 1, 0)

For survey id 23377 flag 0

I also want to show a new condition that whenever the flag is 0,it will also calculate the sum of FUEL_MASS_BEFORE_SOUNDING grouped by Actual_Fuel_Type. And also show the difference between [SOUNDING_START_DATE]- [SURVEY_DATE] if its more than 7 days.Because the report shows no value for flag=0 case

Is it possible to show it in the same table.All values of flag=1 and flag=0 so that whenerver flag1 is true it calculates the computed rob and actual rob fields and when flag=0 then they also fetch the values and also show a difference in number of days between the survey date and sounding date

I have attached my qvd in this regard

Re: How to merge 2 flag condition in same expression.

Sergey_Shuklin — Tue, 21 Aug 2018 11:23:48 GMT

Hello, Trishita!

The data of your dashboard are scrumbled?

Re: How to merge 2 flag condition in same expression.

trishita — Tue, 21 Aug 2018 11:42:10 GMT

I did not understand what you meant..but if flag is 0 for a specific survey id example 23377

And if flag is 1 for any survey id then 23373

My target is to have a report where all values will be displayed if the data is between the specific date range it will show them as computed if not within the date range then also they will show up the data and also a new column which will show that difference between survey date and sounding date if its more than 7

topic Re: How to merge 2 flag condition in same expression. in QlikView

How to merge 2 flag condition in same expression.

Re: How to merge 2 flag condition in same expression.

Re: How to merge 2 flag condition in same expression.