Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
albi_prakash
Creator II
Creator II

Help on Ad - Hoc report

Hi All,

I need to create some Ad-Hoc kind of report.In my scenario I will be having list box

i)PLAN/Budget

ii)PLAN

iii)BUDGET

So when User clicks PLAN/BUDGET I need to show the first 6 months of PLAN & Last 6 Months of Budget in pivot table.

In some of cases I may not have Budget value at all. So in that scenario I need to show all 12 months of PLAN Values.

I have enclosed sample data set

Kindly help me on this.

-Jai

0 Replies