topic Re: How to exclude data in QV? in QlikView

How to exclude data in QV?

Tue, 29 Apr 2014 12:30:54 GMT

Hello!

I'm a beginner in QV but I know some SQL.

In my companys QV-file we read in all datas from our system.
But when I will extrakt the datas I would like as similar result as if I had used "SELECT * FROM DB WHERE data_field NOT 'value1'".

What I got right now is "sum(Utfall_Belopp)" and I have a lot of info in my QV that I have to un-select.

Anyone that please can help me with a nice script.

Re: How to exclude data in QV?

alexandros17 — Tue, 29 Apr 2014 12:33:25 GMT

There is EXISTS instruction, take a look to the Help ...

Hope it helps

Re: How to exclude data in QV?

tresB — Tue, 29 Apr 2014 12:36:01 GMT

You can run the same SQL command in qv, like:

SQL SELECT * FROM DB WHERE data_field NOT 'value1 ;

Re: How to exclude data in QV?

sudeepkm — Tue, 29 Apr 2014 12:38:26 GMT

you can use Match and wildMatch functions to filter out those records as per your requirement.

For example:

Load Name, ID, Addr, Region from Table where not match(Region,'NAMR','LAMR') ;

Re: How to exclude data in QV?

DavidFoster1 — Tue, 29 Apr 2014 12:39:02 GMT

Are you talking about excluding in the load script of your QVW (i.e. reading from a QVD) or excluding from your SUM expression?

Re: How to exclude data in QV?

Tue, 29 Apr 2014 12:44:47 GMT

OK, will check that up. Thanks

Re: How to exclude data in QV?

Tue, 29 Apr 2014 12:45:24 GMT

Exclude from the SUM-expression

Re: How to exclude data in QV?

DavidFoster1 — Tue, 29 Apr 2014 12:49:42 GMT

You need to have a look at SET ANALYSIS. Your SUM expression would be something like

SUM({$<[the field you want to exclude on] -={'value1','value2',etc}>} Utfall_Belopp)

Re: How to exclude data in QV?

tresB — Tue, 29 Apr 2014 12:51:45 GMT

Then try like:

sum({<data_field - ={'Value1'}>}Utfall_Belopp)

Re: How to exclude data in QV?

Tue, 29 Apr 2014 12:56:17 GMT

OK, thanks all!

I will try your suggestions on exclude from the SUM-expression.
I didn't realy understood the guide in "QV11 for developers", QV is too new for me to have a free mind and a see how the script can be "manipulated". 😃

Re: How to exclude data in QV?

DavidFoster1 — Tue, 29 Apr 2014 13:02:51 GMT

No problem Mario.

If you can afford it then Qlik's designer/developer courses are very good.

Re: How to exclude data in QV?

Tue, 29 Apr 2014 13:24:33 GMT

I had one, but almost a year ago, so it is some hours before I get back into it. There was no time to start in connection to the course, but the course was good.