topic Re: Filtering Data in Straight Table in QlikView

Filtering Data in Straight Table

Mon, 25 Aug 2014 15:07:04 GMT

Hello,

I am relatively new to Qlikview and am still getting used to the program itself. I was hoping to seek out the Qlikview community to have a couple of questions answered! I have two questions really regarding how to filter data in qlikview. I currently have a chart with lots of information and in the first column as a dimension I have it ordered by States (MI, WI, NY, etc). Is it possible to write something that will filter it out so I can only get the data for 3-4 specific states?

Also, for the expressions I have a column where I show the sum of the losses. How can I filter that so I'm only looking for a number greater than like 10000? Should I be using if statements?

Thank you!

Re: Filtering Data in Straight Table

jerem1234 — Mon, 25 Aug 2014 15:22:13 GMT

you can try set analysis like:

sum({<State={'MI', 'WI', 'NY'}>}Sales)

and maybe for the sum, try something like:

sum({<State = {'=sum(Losses)>10000'}>}Losses)

where State is the dimension for that chart.

Hope this helps!

Re: Filtering Data in Straight Table

Anonymous — Mon, 25 Aug 2014 15:24:43 GMT

Richard,

If you want to filter data in a qlikview application, all you need to do is to select the values. For example, create a list box State, and select what you need (MI, WI, NY, etc.). If you want to filter data only in the particular object (straight table), it is a different story, but I think you don't need this.

Expression that includes only amounts greater than 10000:
sum(if(Loss>10000, Loss, 0))

Regards,

Michael

Re: Filtering Data in Straight Table

Mon, 25 Aug 2014 15:41:53 GMT

Awesome Michael and Jeremiah thank you!

Michael I ended up using your expressions and they worked out! I was using the list box for the States originally but it seemed as if I could only choose 1 state at a time. Is there something I have to check or write in the expression in order to get the box to select all 3 states at the same time?

Re: Filtering Data in Straight Table

Anonymous — Mon, 25 Aug 2014 15:52:13 GMT

To select multiple States, you need to press and hold CTRL key while clicking on the States.

Re: Filtering Data in Straight Table

Mon, 25 Aug 2014 16:09:08 GMT

Of course should've though that through.

If I want to get rid of losses that amount to less than my desired amount of 10000, is there something else I should put in my expression instead of 0?

Thank you Michael!!!