Discussion Board for collaboration on QlikView Scripting.
I have table like below basically I am doing recon between serverwise daily
I am creating the pivot as below
TrasDate A vs B B vs C A vs C
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
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
You can create one data island for your filter value..like
Load * Inline [
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
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.
Check this.. May be helpful..
Adhoc reporting in Qlikview