Need Help in Scripting

[Anonymous]

I have table like below basically I am doing recon between serverwise  daily

Tab1:

"A" server

TransDate

.

.

NetRevenue_Amt

Inventory_Amt

CostofSales_Amt

Concatenate

"B" server

TransDate

.

.

NetRevenue_Amt

Inventory_Amt

CostofSales_Amt

Concatenate

"C" server

TransDate

.

.

NetRevenue_Amt

Inventory_Amt

CostofSales_Amt

I am creating the pivot as below

TrasDate          A vs B             B vs C     A vs C

(Dimension)

I have  created three pivot for NetRevenue and Inventory and Cost of Sales. But I want create only one pivot with filter box as below

FilterBox

------------

NetRevenue

Cost ofSales

Inventory

based on my selection  on filter box it has show the serverwise difference in pivot

If I load it as crosstable I am getting value column as one field .is there any other way  to get value column has only in filter box so that I would have one piot

T

[settu_periasamy]

You can create one data island for your filter value..like

Filter:

Load * Inline [

Filter

NetRevenue

Costofsales

Inventory

];

And you can use this value in your condional display in expression..(Using the subfield function )

Search Adhoc report or dynamic report in the search box

[Anonymous]

Hi Settu

Thanks for the reply.I understood about conditional display and coul not understand about using subfield function this scenario. Can you explain more about that your idea.

[settu_periasamy]

Hi Ramu,

Check this.. May be helpful..

Adhoc reporting in Qlikview