topic Re: How to remove field values from results? in QlikView

How to remove field values from results?

Thu, 20 Nov 2014 11:57:39 GMT

Hi.

I'm fairly new to qlikview and programming in general and I was wondering if anyone had any ideas about how to remove a field value from a result.

By this I mean I have a field A and the values within the field are 1,2,3,4,5. Is there any flexible formulas whereby I could just remove value 3 from the coding and keep it flexible so that if 6,7,8 etc were to come through in a later upload they would still carry through. The best method I have at the moment is just to lock the field but this is not particularly flexible.

As an aside would anybody have any suggestions as to where to go to learn the basics concepts of the type of programming I might need for qlikview (preferably without costing).

Thanks.

Re: How to remove field values from results?

sujeetsingh — Thu, 20 Nov 2014 12:00:30 GMT

You can use conditional reload

Load

from where B<>3;

You can do this in UI as using expression in list box or calculated dimension in objects

=if(Field=3,null(),Field)

Supress nulls

Re: How to remove field values from results?

Thu, 20 Nov 2014 12:44:45 GMT

Thank you very much. I just basically did the last line but with A which seemed to work for what I wanted. Can you tell me what <> means in terms of coding?

Re: Re: How to remove field values from results?

CELAMBARASAN — Thu, 20 Nov 2014 12:52:07 GMT

<> is just not equal to (!= in other scripting languages).

Re: How to remove field values from results?

Thu, 20 Nov 2014 13:07:01 GMT

It returns anything lesser than '<' or greater than '>' your value... so in essence everything which is not equal to it.