Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

How to limit?

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!

Tags (3)
12 Replies
MVP
MVP

Re: How to limit?

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');

MVP
MVP

Re: How to limit?

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?

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?

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

Not applicable

Re: How to limit?

thanks for your reply.

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

Not applicable

Re: How to limit?

Match is not a SQL function

Not applicable

Re: How to limit?

I am sorry,I am a beginner.

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

Not applicable

Re: How to limit?

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.

Not applicable

Re: How to limit?

thank you so much!