topic Re: How to exclude unwanted data from chart expressions.. in QlikView

How to exclude unwanted data from chart expressions..

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

I just want to display the values corresponding to Flag1=1 or Sounding Date= Date field.

Which means I want to exclude:

Flag1<> 0 or Sounding Date<>'Not Corrected within 7 days'

But I am unable to do so

Re: How to exclude unwanted data from chart expressions..

sunny_talwar — Wed, 08 Aug 2018 11:14:33 GMT

Is this a straight table or table box? If this is a straight table, may be use set analysis to exclude.... if this is a table box... may be use straight table instead because you are not able to use calculated dimensions or set analysis to exclude stuff from the table box...

Re: How to exclude unwanted data from chart expressions..

trishita — Wed, 08 Aug 2018 11:28:32 GMT

Hi Sunny,

I am using straight table as I have used set analysis here before...

I had used the following code :

Flag1:

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

and

And in the column Sounding Date I had put the following code:

If(Flag1=1,Date(SOUNDING_START_DATE,'YYYY-MM-DD'), 'Not Corrected within 7 days')

Now to exclude the Sounding Date='Not Corrected within 7 days'

{$<Sounding Date-='Not Corrected within 7 days'>}

But I am having syntax error: Garbage after expression Date

Re: How to exclude unwanted data from chart expressions..

sunny_talwar — Wed, 08 Aug 2018 11:30:33 GMT

May be try this

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

Also, is that the only expression in your chart? If it is, then you can just check 'Suppress Zero Values' on the presentation tab and 0s from Flag should go away.

Re: How to exclude unwanted data from chart expressions..

trishita — Wed, 08 Aug 2018 12:42:37 GMT

I am continuously getting an error with whatever syntax I am putting with sounding date

Re: How to exclude unwanted data from chart expressions..

neelamsaroha157 — Wed, 08 Aug 2018 12:44:24 GMT

Use Square brackets around the field name

Re: How to exclude unwanted data from chart expressions..

sunny_talwar — Wed, 08 Aug 2018 12:53:30 GMT

Hahahaha

Re: How to exclude unwanted data from chart expressions..

trishita — Wed, 08 Aug 2018 13:19:30 GMT

I did it..now the syntax is working but the results are not what i want..i just want to exclude certain values or filter out...nothing that complicated..I have used other tools where we had direct filter feature..here i cant find it..is there no easy way to filter out stuff..i used the flag so that ican suppress all the values which i dont need

Re: How to exclude unwanted data from chart expressions..

sunny_talwar — Wed, 08 Aug 2018 13:23:22 GMT

I am not sure what you are talking about? May be if you can share a sample to show what you mean, it might help? Filtering in Qlik is not that difficult (can't really compare to other tools, since I have not used them)... you just have to do it right...

Re: How to exclude unwanted data from chart expressions..

trishita — Thu, 09 Aug 2018 08:22:01 GMT

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

Also attached my qvw..but dont know whats the problem

Re: How to exclude unwanted data from chart expressions..

Anil_Babu_Samineni — Thu, 09 Aug 2018 09:54:57 GMT

Don't Dup Syntax error with set analysis expression

Re: How to exclude unwanted data from chart expressions..

sunny_talwar — Thu, 09 Aug 2018 10:07:36 GMT

Is this the chart you are interested in?

What is not right here? What is the expected output?

Re: How to exclude unwanted data from chart expressions..

trishita — Thu, 09 Aug 2018 11:18:13 GMT

Correct: This should be the intended output where I will have this data without selecting the sounding correction date.I mean I want to get this data without selecting any sounding correction date..

Currently what I am getting:

So there is a data mismatch.I had filtered out the data for those days which do not satisfy the condition.But I think the calculation of the fields actual rob and computed rob is not correct...It reflects values from other sounding date as well..I need to modify those calculations with respect to sounding date and survey id...

here is the instance of my sample

Re: How to exclude unwanted data from chart expressions..

trishita — Thu, 09 Aug 2018 11:23:45 GMT

I did not create any duplicate thread.I wanted to create a fresh thread because my problem was not getting solved and people where laughing and making fun of my ignorance,I am completely new to qlikview..I tried many times but the problem persisted .Then in a new thread another person said that the syntax error was not due to any missing brackets but its not allowed to use labelled expression in set analysis.I ddnt know that.And even if i uploaded my last qvw it however was not reflected.So I used a new thread.No hard feelings

Re: How to exclude unwanted data from chart expressions..

sunny_talwar — Thu, 09 Aug 2018 11:25:53 GMT

people where laughing and making fun of my ignorance,I am completely new to qlikview.

Who is laughing and making fun of you trishita‌? We are all professionals here and are looking to help each other out. I didn't see anyone making fun of you here or any other thread you have posted before?

Re: How to exclude unwanted data from chart expressions..

sunny_talwar — Thu, 09 Aug 2018 11:28:26 GMT

Does this look like what you want?

Re: How to exclude unwanted data from chart expressions..

trishita — Thu, 09 Aug 2018 11:54:26 GMT

Yes this looks perfect

Re: How to exclude unwanted data from chart expressions..

trishita — Thu, 09 Aug 2018 11:59:33 GMT

I am new to qlikview and hence its sometimes not easy to understand.Anyhow no hard feelings.

Re: How to exclude unwanted data from chart expressions..

sunny_talwar — Thu, 09 Aug 2018 12:02:15 GMT

Nobody was making fun of you... this was as much a user error on your part as it was mine.... I didn't see it either

Re: How to exclude unwanted data from chart expressions..

sunny_talwar — Thu, 09 Aug 2018 12:02:39 GMT

Awesome, then please close the thread if you got what you wanted.

Best,

Sunny