topic Re: How to set compicate filters , include muliple fields ? in QlikView

How to set compicate filters , include muliple fields ?

yanivvl0 — Sun, 02 Apr 2017 09:10:26 GMT

hi to all ,

i need to set compicate filter on my model , I have BlackID and ID_DATE ,

The supose to be like that :

SHOW ALL BigID's WITH ( ( BlackID = 6 and ID_DATE >= 01/01/1992 ) or ( BlackID = 42 and ID_DATE >= 01/01/1992 ) )

is there any way to set it on list-box advance search , or as bookmark , or any other way ?

THANKS!!

Re: How to set compicate filters , include muliple fields ?

vinieme12 — Sun, 02 Apr 2017 09:42:28 GMT

Use Set Analysis

Count({<BlackID = {6} ,ID_DATE = {">= 01/01/1992"} >} BigID)

Count(if(BlackID=6 and ID_DATE >= 01/01/1992, BigID))

Re: How to set compicate filters , include muliple fields ?

yanivvl0 — Sun, 02 Apr 2017 10:24:26 GMT

hi Vineeth , i need to filter all model , so the population will be according to the condition .

Re: How to set compicate filters , include muliple fields ?

vinieme12 — Sun, 02 Apr 2017 10:26:33 GMT

do you mean in the load script?

Re: How to set compicate filters , include muliple fields ?

Anonymous — Sun, 02 Apr 2017 10:31:33 GMT

Hi Yaniv,

I think the value 6,42 and date are something that you should be able to select in filter.??

If the user selects multiple BlackIDs you need the union of data of all the blackIDs.??

If Yes, Maybe you can use filters for BlackID and Id_Date and write set analysis to get the data, like Vineet mentioned something like Count({<ID_DATE = {">= $(=Max(Id_Date ))"} >} BigID). This will get the data of all the blackIDs selected and for each blackId it will check if the date is greater than or equal to the Id_Date selected in the filter.

Re: How to set compicate filters , include muliple fields ?

Kushal_Chawda — Sun, 02 Apr 2017 10:32:03 GMT

Another solution could be

You can create one button on which you can set the action to select all the BigIDs

Button->Action->Add->Select in field

Field -> BigID

Search string->

='( '& Concat( distinct if(((BlackID = 6 and floor(ID_DATE) >= floor(date#('01/01/1992','DD/MM/YYYY')) or ( BlackID = 42 and floor(ID_DATE) >= floor(date#('01/01/1992','DD/MM/YYYY')),chr(34)&BigID&chr(34)),'|') & ')'

On clicking of this button all the BigIds will get selected

Re: How to set compicate filters , include muliple fields ?

sunny_talwar — Sun, 02 Apr 2017 10:59:35 GMT

Are you looking to select a particular row which meets the condition or if one of the row meets the condition, you will select the whole BigID? If you are looking to select a particular row, I think you will need to have a unique identifier.

Would you be able to share a qvw with your expected output?

Re: How to set compicate filters , include muliple fields ?

yanivvl0 — Mon, 03 Apr 2017 07:45:10 GMT

hi to all , i solved the problem in the DB level , thanks !!

Re: How to set compicate filters , include muliple fields ?

Anonymous — Mon, 03 Apr 2017 09:07:43 GMT

Nice Please close the thread.

Re: How to set compicate filters , include muliple fields ?

yanivvl0 — Mon, 03 Apr 2017 12:08:34 GMT

how can i do it , dont see in edit the option.

Re: How to set compicate filters , include muliple fields ?

Anonymous — Mon, 03 Apr 2017 12:10:09 GMT

I mean, mark your answer as correct answer or select assumed answered.

Re: How to set compicate filters , include muliple fields ?

yanivvl0 — Tue, 04 Apr 2017 05:53:34 GMT

thanks