topic Re: Drill down report for comparative analysis in QlikView

Drill down report for comparative analysis

ashishbhuyekar — Wed, 31 Jan 2018 17:26:55 GMT

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?

Re: Drill down report for comparative analysis

Anil_Babu_Samineni — Thu, 01 Feb 2018 00:24:55 GMT

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.

Re: Drill down report for comparative analysis

ashishbhuyekar — Thu, 01 Feb 2018 16:51:40 GMT

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

Anil_Babu_Samineni — Thu, 01 Feb 2018 17:05:02 GMT

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

Re: Drill down report for comparative analysis

ashishbhuyekar — Thu, 01 Feb 2018 20:27:20 GMT

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

Re: Drill down report for comparative analysis

ashishbhuyekar — Thu, 22 Mar 2018 17:08:56 GMT

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