# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

New Contributor III

## Drill down report for comparative analysis

Hi All,

Good Evening !!!

I am developing a comparative report which will show the comparison between to two months. Will it be possible to show , Drill down report to show the data difference between two months?

Example –

Month 1 has Values = 1,2,3

Month 2 has Values = 1,2,3,4,5

In output – I need to show the 4,5 in Straight table/Table box.

Can someone please guide me on this? For your information, I am able to show KPI numbers (Month 1 Total = 3 & Month 2 Total = 5) but unable to show drill down details?

1 Solution

Accepted Solutions
Highlighted
New Contributor III

## Re: Drill down report for comparative analysis

Did ample amount of research but it seems the way I am trying to do is not possible.

5 Replies

## Re: Drill down report for comparative analysis

This make sense, But the only thing i would ask you to build the same in Data model rather Front-End.. And, So when we opened thread using Drill Down that means you need to allocate P() and E() are in place.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
New Contributor III

## Re: Drill down report for comparative analysis

Thanks Anil for response. Can you please give me some example of P() & E() i.e. how in this case i can able to use it?

Also I am using alternate states to compare data between two sets. Output currently I am getting is all the results from SET1 where as i want to show only the difference in straight table. Is it possible to do it?

Expression I used in this case -

=SUM({(SET1 - SET2)} SALES

## Re: Drill down report for comparative analysis

Please fill that expression? What are the Set1 and SEt2??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
New Contributor III

## Re: Drill down report for comparative analysis

SET1 & SET 2 are alternate states which are assigned to two different selections.

Highlighted
New Contributor III

## Re: Drill down report for comparative analysis

Did ample amount of research but it seems the way I am trying to do is not possible.