Script Issue

[#1]

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

[Anonymous]

Hi

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

[maxgro]

please post the excel (demo.xlsx)

[jaimeaguilar]

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

[MarcoWedel]

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

[#6]

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

[#7]

I have explained and attached sample demo files

[Anonymous]

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

[#9]

ok Thanks for your reply