Question - Field & Value Filtering

[#1]

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.

[m_woolf]

Look at alternate states

[#3]

Thanks

[maksim_senin · Accepted solution]

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

[#5]

Maxim,

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