adding columns dynamically to report

[arusanah]

Hi ,

I'm creating a report to display monthly customer sale .

My requirement is to have flexibility to select date range . and based on that range it should add columns to table or Pivot report.

I know we need two input boxes for  from date and to date.but then dont know how to generate runtime columns in report .

e.g Product category , Productn description , <n months customer sales >

pls help

[robert_mika]

Is that adding column to PivotTable or to final Report?

Could you draw a sketch how this should look like?

Here is a post with the same? problem

Dynamic columns on Qlikview Report

[jagan]

Hi,

Check this link for dynamically adding columns into the pivot table.

Adhoc reporting in Qlikview

Regards,

Jagan.

[Anonymous]

You can also see the qlikview example What's new in qlikview 11 qvw.

You can find it in your installation directory.

C:\Program Files\QlikView\Examples\Documents

Thanks

BKC

[arusanah]

Hi Jagan ,

the sample you sent adds fields based on selection of dimensions.

my requirement is I have two input boxes. from date and todate. when user selects a date e.g

from Date -3/12/2014  and todate=3/12/2015

so 12 columns should be added to show customer sales for all the months , so if they want to see 3 yrs sales 36 columns should be added like  jan-14 | feb14 so on and so fort

[Anonymous]

From your description looks like the only thing you need to do is to have Month as dimension, and keep it on top, not on the left.

[arusanah]

No Michael,

My date fields are like filter , i need to see data for only selected date range .

[arusanah]

Hi ,

adding columns to my Pivot report

[ramoncova06]

create a calculated dimension that shows the months based on date and todate, and then suppress the null values

something like if(date >= yourdate and todate <= yourdatefield, month)

not sure on how the performance would be, but that way you will dynamically add the columns you want

[Anonymous]

This is fine, I don't see contradiction so far...  Can you upload an example of your app?