topic Re: adding columns dynamically to report in QlikView

adding columns dynamically to report

arusanah — Wed, 22 Apr 2015 02:10:19 GMT

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

Re: adding columns dynamically to report

robert_mika — Wed, 22 Apr 2015 04:07:55 GMT

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

Re: adding columns dynamically to report

jagan — Wed, 22 Apr 2015 04:21:55 GMT

Hi,

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

Adhoc reporting in Qlikview

Regards,

Jagan.

Re: adding columns dynamically to report

Anonymous — Wed, 22 Apr 2015 05:13:47 GMT

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

Re: adding columns dynamically to report

arusanah — Wed, 22 Apr 2015 13:46:40 GMT

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

Re: adding columns dynamically to report

Anonymous — Wed, 22 Apr 2015 13:49:21 GMT

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.

Re: adding columns dynamically to report

arusanah — Wed, 22 Apr 2015 14:32:11 GMT

No Michael,

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

Re: adding columns dynamically to report

arusanah — Wed, 22 Apr 2015 14:32:42 GMT

Hi ,

adding columns to my Pivot report

Re: adding columns dynamically to report

ramoncova06 — Wed, 22 Apr 2015 14:45:54 GMT

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

Re: adding columns dynamically to report

Anonymous — Wed, 22 Apr 2015 14:58:22 GMT

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

Re: adding columns dynamically to report

arusanah — Wed, 22 Apr 2015 17:07:12 GMT

will surely try and upload the app!

thanks

Re: adding columns dynamically to report

arusanah — Wed, 22 Apr 2015 17:14:30 GMT

Thatz just an Adhoc report . this is not my exact requirement.

My requirement is i have 2 dimensions PG Category and PG Desc . i want to see mon-Year sale against them.

I created 2 calander objects From date and To date. based on date range its should display me sales if date range is 12 months it should show me 12 columns , if date range has 36 months , it should add 36 columns like that .

Re: adding columns dynamically to report

arusanah — Wed, 22 Apr 2015 20:30:45 GMT

Product

PG Group

Product Desc

Date

8-3-2012

…

….

…..

3/30/2015

Product group

Product Desc

MONTH-YEAR(based on date range selection)

Jan-13

Feb13

Jan15

(Customer sales)

Month year column needs to be added dynamically. E.g if users selects jan 13 – jun 13 only 6 columns should be added to show customer sale jan thru jun. if user selects jan 14-jan 15 .. 12 columns should be displayed to show monthly sales and like wise.

Re: adding columns dynamically to report

Anonymous — Wed, 22 Apr 2015 20:57:20 GMT

Last attempt to help...

See the attached file. There is Dim2 filter. Whatever you select will be on the columns of the pivot table.

In case of months, the difference is only in details. The fact that the selection is made using "to" and "from" doesn't change anything.

Re: adding columns dynamically to report

arusanah — Wed, 22 Apr 2015 21:16:36 GMT

But where is attachment??

Thank Michael. i'm new to QV development and so facing lots of issues .. I'm Kind off stuck in a dead end

every bodies help is much appreciated.

Re: adding columns dynamically to report

arusanah — Wed, 22 Apr 2015 21:33:05 GMT

U r Life Saver Ramon. Thank You So veryyyyyyy much

Re: adding columns dynamically to report

arusanah — Wed, 22 Apr 2015 21:47:38 GMT

Michael in the Qvw you sent .. it works fine but the only problem is it is not adding columns . it just changes column . e.g when i select value a from DIM table ..report displays

dim 1 dim2 column a . . i change my select to b

i see dim1 dim2 column b

where as my requirement is if i select first date form Dim1

second date from Dim2 then report should display all columns between that date range

Re: adding columns dynamically to report

Anonymous — Wed, 22 Apr 2015 22:32:37 GMT

OK, the very last time...

You misunderstood - Dim2 is your only Month field. Dim1 has nothing to do with it. That is, all selections for month are in one field, in this case Dim2. You select "months" from a to b - you get them in the table.

As I've mentioned above, the fact that the selection is made using "to" and "from" doesn't change anything. not in the table at least.

See an updated example. I only renamed Dim2 to Month, and made the values to be from Jan to June 2015. In addition, created two calendar objects where you can select start and end dates. Nothing's changed in the table. the list box Month here is read-only so you can make selections there only by the means of the calendar objects.

(If you select End date < than Start date, you get all months. Sorry, I didn't bother to address that because it's not what your question about.)

Hope it helps...

Re: adding columns dynamically to report

arusanah — Thu, 23 Apr 2015 03:31:52 GMT

Thank you so very much Michael!!!! This is exactly what i was looking for wanted .

some body rightly said -> try try till you succeed .

Would you mind if I add you to my connections ?

Re: adding columns dynamically to report

arusanah — Thu, 23 Apr 2015 03:33:29 GMT

How can I Mark it as correct answer ?