topic Re: Creating auto generated columns in QlikView

Creating auto generated columns

Anonymous — Tue, 09 Dec 2014 07:47:53 GMT

Hi all,

So I have a table showing some data for rolling 12 months (Last 12 months from Today()). Now every measure in this table has same logic for each column (Month). Have a look at the following example:

	Jan 2014	Feb 2014	Mar 2014	Apr 2014	May 2014	Jun 2014	Jul 2014	Aug 2014	Sep 2014	Oct 2014	Nov 2014	Dec 2014
Revenue
Forecast
Budget

Is there a way to create the columns dynamically, as for example, to calculate Revenue the logic remains same for each column but for every iteration the month changes.

Thanks.

Re: Creating auto generated columns

MK_QSL — Tue, 09 Dec 2014 07:50:13 GMT

Do you want to create MonthYear for 2014 only or is there any specific logic (i.e. last 12 months) behind this?

Kindly provide some more information...

Re: Creating auto generated columns

Tue, 09 Dec 2014 08:04:42 GMT

you can create table with auto genenated column by uing ValueList in calculated dimension.

Re: Creating auto generated columns

Anonymous — Tue, 09 Dec 2014 08:04:52 GMT

Yes there is a logic.

The 12 months will be populated according to today's date. Similarly, the values of Revenue, Forecast and Budget will be calculated for each populated month.

For example: today is 9th Dec so, the data will be shown for rolling 12 months i.e. 10th dec 2013 to 9th dec 2014.

Re: Creating auto generated columns

MK_QSL — Tue, 09 Dec 2014 08:22:25 GMT

I am not going to create a Database for giving the answer but if you have data, you can use below to create your expressions

Label of Expression

Date(MonthStart(Today()),'MMM-YYYY') //This will give you Dec-2014

Expression

SUM({<Date = {">=$(=AddYears(Today()+1,-1) )<=$(=AddYears(Today(),0))"}>}Revenue)

For Nov-2014

Date(MonthStart(Today(),-1),'MMM-YYYY')

SUM({<Date = {">=$(=AddYears(Today()+1,-2) )<=$(=AddYears(Today(),-1))"}>}Revenue)

Hope this would help

Re: Creating auto generated columns

Wed, 10 Dec 2014 04:33:12 GMT

Hi utkarsh garg

R u looking to add dynamic columns according to the selection

plz let me now

i will send u qvw file

Re: Creating auto generated columns

Wed, 10 Dec 2014 05:13:36 GMT

http://community.qlik.com/blogs/qlikviewdesignblog/2014/11/21/hideprefix-hiding-fields