If with a search string

coxanagi — Fri, 30 Jan 2015 16:46:15 GMT

Hello!

I want to display in a Text Object a Date, only for some companies. I can identify the foreign companies by its ID, the foreign companie's ID start with 'PE_____' and the national companie's ID start with 'PN_____' So I need to substract 30 days to foreign companie's date y display it. I tried it with a search string but something goes wrong.

This is the expresison that I tried to use

= if ( [COMP_ID]="PE*", 'Date ' &Chr(10)&(Date(MIN( [Registration Date])-30) ) , 'Date '&Chr(10)&(Date(MIN([Registration Date]) ) ) )

Re: If with a search string

Anonymous — Fri, 30 Jan 2015 16:50:59 GMT

Hello,

you can try with [COMP_ID] like 'PE*'

Elena

Re: If with a search string

coxanagi — Fri, 30 Jan 2015 16:54:21 GMT

It works Thank you!!

topic Re: If with a search string in QlikView

If with a search string

Re: If with a search string

Re: If with a search string