topic Re: Question - Field & Value Filtering in QlikView

Question - Field & Value Filtering

Thu, 16 Apr 2015 18:02:16 GMT

Good Afternoon,

I am rather new to the Qlik application, I am currently evaluating the application for my organization and I am very impressed with the functionality and how it works in general. I do have a question...

I am connecting directly to my ERP server (SQL Server) and I have a field in the Invoice Table called "FISYR" now I am able to filter the original loading of data to 2014 and greater using a WHERE statement. However what I am looking to do is create a new Dimension that I can filter just sales for 2014 and then create a second filter for 2015... now this could be a year over year or a period over period

Thank you for your suggestions and help.

The idea is that I can show something like the image below.

Re: Question - Field & Value Filtering

m_woolf — Thu, 16 Apr 2015 18:59:16 GMT

Look at alternate states

Re: Question - Field & Value Filtering

Thu, 16 Apr 2015 19:07:22 GMT

Thanks

Re: Question - Field & Value Filtering

maksim_senin — Tue, 14 Jul 2015 04:56:08 GMT

Hi,

It looks rather like a necessity to have a like-for-like comparison and here it's better to use a power of set analysis in order to be able to compare the same set of filters in different time periods. E.g. if you want to compare sales in certain regions in the year of 2015 with the same period of the year 2015 you need to select regions and create two expressions with set analysis like follows (just for demo):

Sum({<Year={2014},Month={1,2,3,4,5,6}>} SalesAmount)

Sum({<Year={2015},Month={1,2,3,4,5,6}>} SalesAmount)

This is far better of alt. states since it does not require to duplicate selection over all alt. states.

Best regrads,

Maxim

Re: Question - Field & Value Filtering

Tue, 14 Jul 2015 13:20:37 GMT

Maxim,

Thank you so much, I just put this formula in to the system and it worked great. Thank you.