topic Re: Selection Format in QlikView

Selection Format

Fri, 21 Mar 2014 17:17:50 GMT

Hello, i Was just wondering whats the correct format for some selection's at the script with the Where clause.

Im currently extracting some info, and to do some filters i need to filter just account number 10 and 11.

At the where clause i use Where( AccNum = '10' or AccNum='11') and Year='2000' but i dont think its working.

I remeber once seeing and example that i cant find right now that used like {'10''11'} or something like that but im not quite sure how the format goes.

Does anyone knows how to do this?

thanks,

Re: Selection Format

its_anandrjs — Fri, 21 Mar 2014 17:34:17 GMT

Hi,

Use SET Analysis for this like

sum({$<Year={2000}, AccNum ={10,11}>} Sales)

Hope this helps

Thanks & Regards

Re: Selection Format

Fri, 21 Mar 2014 17:38:58 GMT

Hi,

If you want to filter the data on the back-end itself then you can use this:

Where Match(Accno,10,11) and Year='2000' ;

The thing to notice here is 10 and 11 should be number fields and make sure Year is in the right format.

If you want to use this on some calculations on the front-end you can use it as mentioned by Anand.

Re: Selection Format

its_anandrjs — Fri, 21 Mar 2014 17:47:16 GMT

Hi,

If you work on this in expression part then use

Expression = sum({$<Year={2000}, AccNum ={10,11}>} Sales)

But in load script it works like

Load

Accno,

Year

statements

From location

Where Match(Accno,10,11) and Year='2000' ;

like this you have use Yes as Ajay say you have to check your data format of the field then you have to use fields.

Hope this helps

Thanks & Regards