topic Re: Script Issue in QlikView

Script Issue

Tue, 05 Aug 2014 10:39:24 GMT

Hi QV,

I was been facing some script issue for a long time,I have attached sample data files and explained about the requirement ,can any one help me on it.

Thanks in advance,

Swathi

Re: Script Issue

Anonymous — Tue, 05 Aug 2014 21:16:53 GMT

What are you trying to achieve?, the script in the qvw doesn't explain anything.

Re: Script Issue

maxgro — Tue, 05 Aug 2014 21:29:27 GMT

please post the excel (demo.xlsx)

Re: Script Issue

jaimeaguilar — Tue, 05 Aug 2014 21:49:32 GMT

Jaime

Could you please elaborate a little bit more your question? the sample qvw doesn't have any records. Also it would be useful if you post the excel file,

regards

Re: Script Issue

MarcoWedel — Tue, 05 Aug 2014 23:00:56 GMT

Hi Swathi,

you are using aggregation functions (min, max) without group by.

So you have to add

Group By SNO_WEEK

at the end of your load statement.

Another point is that you load the field FISCAL_YEAR_WEEK_NUM directly and also apply aggregatio functions to this same field in one single load.

As already suggested, you might describe a bit more about your requirements and add some data.

hope this helps

regards

Marco

Re: Re: Script Issue

Wed, 06 Aug 2014 05:42:33 GMT

Hi All,

Thanks for all your valuable replies.I have attached the sample demo xsl here.

I have two tables ,I want to create a new Time Line row and wants to append this row to my table .

my output looks like below table format and I have attached the same .

MSD_ID	Sum(PRIOR_FW_VAL) a	Sum(PRIOR_MONTH_VAL)	Sum(PRIOR_QTR_VAL)	Sum(PRIOR_YR_VAL)
I want to append new Time Line row this table.
Time Line	FW17	FW13-FW17	FW02-FW17	FW30-FW17
A	13	28	47	62

To create TimeLine new row I need to follow below things

If(SNO_WEEK=1,'FW' & Right(FISCAL_YEAR_WEEK_NUM,2)) as PRIOR_FW_VAL,

If(SNO_WEEK >= 1 and SNO_WEEK <= 4,'FW' & Right(Max(FISCAL_YEAR_WEEK_NUM),2) &'-' &'FW' & Right(Min(FISCAL_YEAR_WEEK_NUM),2)) as PRIOR_MONTH_VAL,

If(SNO_WEEK >= 1 and SNO_WEEK <= 13,'FW' & Right(Max(FISCAL_YEAR_WEEK_NUM),2) &'-' &'FW' & Right(Min(FISCAL_YEAR_WEEK_NUM),2)) as PRIOR_QTR_VAL,

If(SNO_WEEK >= 1 and SNO_WEEK <= 52,'FW' & Right(Max(FISCAL_YEAR_WEEK_NUM),2) &'-' &'FW' & Right(Min(FISCAL_YEAR_WEEK_NUM),2)) as PRIOR_YR_VAL

but I am unable to succeed,I have attached sample data files can any one suggest me how we can do it.

thanks

Re: Script Issue

Wed, 06 Aug 2014 19:09:04 GMT

I have explained and attached sample demo files

Re: Script Issue

Anonymous — Wed, 06 Aug 2014 21:31:04 GMT

Hi Swathi,

The formulas as they are are asking the system to find the Min and Max of a single number. I think you may need to look at ways to do that Part in the UI of Qlikview, I haven't investigated it yet but you may need to look at variables.

Bella

Re: Script Issue

Thu, 07 Aug 2014 05:28:06 GMT

ok Thanks for your reply