topic Re: Maybe use an Inline statement in QlikView

Maybe use an Inline statement

Anonymous — Wed, 23 Aug 2017 15:01:31 GMT

I have two tables that I am joining. They have the same data with the exception of a few calculations. Each table has customer 1,2,3,4,5. I want to compare table 1 vs table 2. so for example Customer 1 vs Customers 2,3,4,5 so I want to allow my end user to select a filter that will filter the first view and another filter to filter the second view. Can someone give me an example of this. Maybe create an inline statement for the second table. Just to add since these two views are joined so that I am able to get the data on the same row for the comparison.

Re: Maybe use an Inline statement

marcus_malinow — Wed, 23 Aug 2017 15:07:02 GMT

Hi Teresa,

suggest you post a sample data set and your expected results.

Sounds like you might be looking at something involving alternate states.

Why Comparative Analysis

Marcus

Re: Maybe use an Inline statement

Anonymous — Wed, 23 Aug 2017 15:50:54 GMT

Here is a sample of what I am talking about.

Filter 1 Filter 2

Customer 1 Customer 1

Customer 2 Customer 2

Customer 3 Customer 3

Customer 4 Customer 4

one chart based on the two filters. The first filter changes the Red bar and the second filter changes the second bar.

The data looks like this. So the first filter, the user picked customer 1, the second filter the user picks customer 2.

Re: Maybe use an Inline statement

marcus_malinow — Thu, 24 Aug 2017 11:52:33 GMT

Hi Teresa,

this looks like you need to use alternate states - check the link I posted earlier for more details.

the data you posted doesn't make much sense to me - for example, although you highlighted a value of -0.7 for customer 2, you alsy have it in it's own row as 1.1. Suggest you structure your data with just three columns - customer, value and data.

Marcus

Re: Maybe use an Inline statement

Anonymous — Tue, 07 Nov 2017 14:33:47 GMT

This is what I ended up doing. I created two Alternate States and then in my calculations I used the below technique. This took care of the two alternate states (the main filters that were not common) and then the filters that are common between the alternate states.

sum( {AS_T10 < [Eff Year] = $::[Eff Year], [Eff Month] = $::[Eff Month] >}Growth_Percent_A)

and for the second filter I used this.

sum( {AS_Broker < [Eff Year] = $::[Eff Year], [Eff Month] = $::[Eff Month] >}Growth_Percent_B)