topic Re: Display fixed months in columns in QlikView

Display fixed months in columns

Tue, 16 Oct 2012 02:10:31 GMT

Hi,

I'm pretty new to Qlikview and I've been asked to display a straight table box with 12 months of datae. I created a calendar with the following fields.

- trxdate

- calyear (yyyy)

- calmmm (JAN, FEB, MAR, ...)

- calmonth (01, 02, ...)

I need to display OCT sales in column 1, NOV sales in column 2, DEC sales in column 3 and so on, always. My sales field is SalesAmt. Depending on the month selected, that month will be hightlighted.

I don't know if there exists something like an array function where I can simply put calmonth(1) SalesAmount, calmonth(2) SalesAmount, etc ...

I haven't coded anything yet I'm still in the analyzing stage.

Thanks.

Re: Display fixed months in columns

thomas_skariah — Tue, 16 Oct 2012 02:41:00 GMT

Hi,

Find the attached application,but iam not sure you are looking for this.

Regards,

Tom

Re: Display fixed months in columns

Fri, 26 Oct 2012 17:17:15 GMT

Hi,

I was able to solve the problem by hard coding the month for each column:

Sum({$<calmonth = {01}>} invc_salesunits), Sum({$<calmonth = {02}>} invc_salesunits), Sum({$<calmonth = {03}>} invc_salesunits), etc ...

Thanks.