topic Re: How to limit? in QlikView

How to limit?

Wed, 02 Jul 2014 08:01:20 GMT

Hi there,

I need to limit the content of the two fields: one is open data, between 2014/06/01 and 2014/07/01; the other is country, include China, Hong Kong, Taiwan, Japan and Korea.

I want to know how to limit? thank you!

Re: How to limit?

MK_QSL — Wed, 02 Jul 2014 08:05:34 GMT

You want script side... if yes you can use like

Load

From TableName

Where Date >= Date(2014/06/01,'YYYY/MM/DD') and Date >= Date(2014/07/01,'YYYY/MM/DD') and

Match(Country, 'China', 'Hong Kong', 'Taiwan', 'Japan','Korea');

Re: How to limit?

tresB — Wed, 02 Jul 2014 08:06:19 GMT

May be like:

Load

From <> Where DateField>='2014/06/01' and DateField>='2014/07/01' and Match(CountryField , 'China', 'Hong Kong', 'Japan', 'Korea');

Re: How to limit?

its_anandrjs — Wed, 02 Jul 2014 08:10:34 GMT

Try like

Load

From Location Where ( DateField >= '2014/06/01' and DateField <= '2014/07/01' ) and

Match(country, 'China', 'Hong Kong', 'Japan', 'Korea');

Re: How to limit?

avinashelite — Wed, 02 Jul 2014 11:59:33 GMT

Hi Bing Bin,

If you want to limit the data at the opening of the file and need to reuse field values again, use Triggers on the two fields.

go to > settings > Documents Properties> Triggers> on open > add actions

Regards,

Avi

Re: How to limit?

Wed, 02 Jul 2014 15:36:44 GMT

thanks for your reply.

there is some error message ,could you please help me solve it? thank you!

Re: How to limit?

Wed, 02 Jul 2014 15:39:14 GMT

Match is not a SQL function

Re: How to limit?

Wed, 02 Jul 2014 15:48:22 GMT

I am sorry,I am a beginner.

I want to filter field ' work_group' with 'China', 'Japan', 'Korea' etc, could you please help me?

Re: How to limit?

Wed, 02 Jul 2014 15:52:47 GMT

WHERE WORK_GROUP in ('Administration', 'Call Administrator', 'System Administrator', 'CNA_CCR')

The SQL SELECT statement is just that, a SQL statement, which means the error being returned to you is a SQL error.

Re: How to limit?

Wed, 02 Jul 2014 16:02:52 GMT

thank you so much!

Re: How to limit?

Wed, 02 Jul 2014 16:33:07 GMT

Hello Andrew,

one more question:

I want to filter field ' work_group' include 'CN', 'JP', 'KR'. such as ' CNA_CCR', 'CNB_CCR', 'JPD_GCC' etc.

Could you please help me?

Re: How to limit?

Wed, 02 Jul 2014 16:57:30 GMT

WHERE Work_Group in ('Administration', 'Call Administrator', 'System Administrator') OR Work_Group like '%CN%' OR Work_Group like '%JP%' OR Work_Group like '%KR%'

mark as answered if this resolves your question

Re: How to limit?

jer_2011 — Wed, 02 Jul 2014 17:14:22 GMT

try with:

where work_group in ( 'CHINA', 'JAPAN','COREA')