Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ramusubramani
New Contributor II

Need Help in Scripting

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

3 Replies

Re: Need Help in Scripting

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

ramusubramani
New Contributor II

Re: Need Help in Scripting

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

Hi Ramu,

Check this.. May be helpful..

Adhoc reporting in Qlikview

Community Browser