topic Need Help in Scripting in QlikView

Need Help in Scripting

Anonymous — Fri, 19 Feb 2016 14:50:45 GMT

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

Re: Need Help in Scripting

settu_periasamy — Fri, 19 Feb 2016 23:03:34 GMT

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

Re: Need Help in Scripting

Anonymous — Tue, 23 Feb 2016 07:14:51 GMT

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.

Re: Need Help in Scripting

settu_periasamy — Tue, 23 Feb 2016 07:47:45 GMT

Hi Ramu,

Check this.. May be helpful..

Adhoc reporting in Qlikview