topic Re: Syntax error with set analysis expression in QlikView

Syntax error with set analysis expression

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

Can anyone tell me what is wrong with my syntax here?

Only({$<Sounding Date -= {'N'}>} If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, 1, 0))

I have also added my qvw with this reference

Re: Syntax error with set analysis expression

tresB — Thu, 09 Aug 2018 08:34:06 GMT

Couple of issues:

There is no field called 'Sounding Date' in your model. If you are wishing the expression label could be used in set analysis. You are wrong.
Had this even be a field, since there is space in between in the name, you have to enclose this field name within '[' and ']' or double quotes (" ")

Re: Syntax error with set analysis expression

trishita — Thu, 09 Aug 2018 08:47:39 GMT

But I created an expression called Sounding Date:

Sounding date :

If(Flag1=1,Date(SOUNDING_START_DATE,'YYYY-MM-DD'), 'N')

So cant I use expressions in set analyisi

Re: Syntax error with set analysis expression

tresB — Thu, 09 Aug 2018 08:51:41 GMT

No. That is what precisely I wrote in first point above. You have to use field instead in set analysis.

Re: Syntax error with set analysis expression

trishita — Thu, 09 Aug 2018 08:52:36 GMT

I gave a flag called Flag1:

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

Then I created an expression:

Sounding date :

If(Flag1=1,Date(SOUNDING_START_DATE,'YYYY-MM-DD'), 'N')

Lastly I want to show the data for Sounding Date {$<Sounding Date -= {'N'}>}

which means I want to exclude out all date with value N and only display the values for Flag1=1

I dont know whats wrong with my method:

Re: Syntax error with set analysis expression

trishita — Thu, 09 Aug 2018 08:54:57 GMT

So what could be a possible solution to only pick those data with flag1=1?

Re: Syntax error with set analysis expression

tresB — Thu, 09 Aug 2018 09:02:16 GMT

Do you wish to suppress all the other rows from the chart ?

Re: Syntax error with set analysis expression

trishita — Thu, 09 Aug 2018 09:14:48 GMT

yes i just want to show the data which has the value of flag 1.Something like this

Re: Syntax error with set analysis expression

tresB — Thu, 09 Aug 2018 09:25:06 GMT

PFA

Re: Syntax error with set analysis expression

trishita — Thu, 09 Aug 2018 09:28:58 GMT

I also tried to use a calculated dimension using If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, 1, 0) and then tried to supress null value from it..Still its not working

Re: Syntax error with set analysis expression

Anil_Babu_Samineni — Thu, 09 Aug 2018 09:30:48 GMT

Try this final?

If(Output <> 'N', 1)

Where as Output comes from -- Hide From presentation if not required

If(Flag1=1,Date(SOUNDING_START_DATE,'YYYY-MM-DD'),'N')

Where as Flag1 comes from -- Hide From presentation if not required

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

Or this as final

If(Not WildMatch((If(Match(If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, 1, 0),1)=1,Date(SOUNDING_START_DATE,'YYYY-MM-DD'),'N')),'N'), 1)

Re: Syntax error with set analysis expression

tresB — Thu, 09 Aug 2018 09:45:29 GMT

Have you checked the attachment?

Re: Syntax error with set analysis expression

trishita — Thu, 09 Aug 2018 09:51:17 GMT

Hi Tresco,

Thanks a lot for the flag 2 option you had inserted.But the problem is that now I am having erroneous date for the two fields computed ROB and Actual ROB.My target was to compute Actual ROB and Computed ROB for a specific Survey Date and a sounding date which falls within the specific condition..when I do seect the sounding date then it appears fine..The below image shows the intended value:

But with the flag what you sent me was:

How can I change the Computed Value or Actual Value only for specific Sounding date then?My target value is this without selecting the sounding date manually.Which means I want to have the exact data without choosing any sounding date from the data....

Re: Syntax error with set analysis expression

trishita — Thu, 09 Aug 2018 10:06:13 GMT

Yes I checked.First of all thanks a lot for the changes you made.That would be one of the things which I would like to see,excluding the unwanted data.Much appreciation.Secondly what I discovered was the data for the fields Computed ROB and Actual ROB are not showing as they should.They are showing sum of fuel for other sounding dates.

How can I change the two quantities Computed ROB and Actual ROB depending on Survey ID, Survey Date and Sounding Date which suffices the following condition(If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, 1, 0))..When I have the correct quantity I would delete the unwanted data with flag1 and flag2 discussed by you..

The logic for my actual rob field is:

If(flag2=1,

if (Match([Actual_Fuel_Type],'HSFO'), sum( total {$<Actual_Fuel_Type={'HSFO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'LSDO'), sum( total {$<Actual_Fuel_Type={'LSDO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'HSDO'), sum( total {$<Actual_Fuel_Type={'HSDO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'ULSFO'),sum( total {$<Actual_Fuel_Type={'ULSFO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),'Unknown'

))))

)

Re: Syntax error with set analysis expression

sunny_talwar — Thu, 09 Aug 2018 10:16:30 GMT

Is this the same issue we were discussing here?

How to exclude unwanted data from chart expressions..

Re: Syntax error with set analysis expression

trishita — Thu, 09 Aug 2018 10:43:08 GMT

A bit but not fully...but with the same project and some new issues