topic Re: Comparing 2 months data in a table in QlikView

Comparing 2 months data in a table

Anonymous — Thu, 09 Feb 2012 07:02:37 GMT

Hi, I need help in creating a Pivot or Straight Table with following kind of Data. Its mainly comparing 2 months data. In the below example I have data for 2 months Jan and Feb for a perticular Group and sub group, which shows a movevent (Positive or Negative) for each month. Now I need to show all the data which has a negative movement in the month of Feb (Row 11 and 15). Along with that I need to show the movement of the same in its previous month i.e: JAN. Either in a table or in Pvt Table. Please help me resolving as I am not able to put 2 months data in the Pvt Table.

Comparing 2 months data in a table

v_iyyappan — Thu, 09 Feb 2012 08:14:10 GMT

Hi,

You use Set Analysis Expression ' Count( {$<Movement = {Negative}>} 1) '. You will get the MonthWise Negative

Movement .

Hope its useful for u .

Regards,

Iyyappan.

Re: Comparing 2 months data in a table

kaushiknsolanki — Thu, 09 Feb 2012 08:15:40 GMT

Hi,

Have a look at the attached application.

Regards,

Kaushik Solanki