Issue ? Urgent

[#1]

I  Have 30 records, from 1-jan -2014  to 28-feb-2014.

but I want to retreive records which r present between 10-jan-2014 to 5-feb-2014,  how can i get those records ?

1. Using Set Analysis

2.  With out using Set Analysis

Thanks,

Helen

[kumarnatarajan]

Hi,

Using Set  Anlysis

sum( {$<Date= {“>=10-jan-2014 <=5-feb-2014”}>} Sales )

without Set  Anlysis

Sum(if(Date>='10-jan-2014' and Date<='5-feb-2014',Sales))

[#3]

If I want to Select dynamically the dates then ?

[#4]

1) With set analysis:

Create 2 variables:

v_DateStart=num(10-jan-2014)

v_DateEnd=num(5-feb-2014)

sum( {$<Date= {“>=$(v_DateStart) <=$(v_DateEnd)”}>} Sales )

2) Without set analysis:

use a custom dimension in chart or table like this:

if(Date>=$(v_DateStart) and Date<=$(v_DateEnd), Date)

and your expression (ex. sum(1))

Hope this helps

MC

[kumarnatarajan]

Hi,

use min, max function for dynamic

Ex

sum( {$<Date= {“>= $(=Min(Date)) <= $(=Max(Date))”}>} Sales )

[#6]

so you can use a list box to select dynamically your date and the you graphic react with your selection

[sunilkumarqv]

Hi helen

I did this in my project its worked try these

Use in script

set dataformat='DD/MM/YYYY';

Let MinDate='10-01-2014 ';

Let MaxDate=' 5-2-2014';

use these in experssion

=    sum({<num(Data)={">=$(MinDate)<=$(MaxDate)"}>} sales)

[#8]

Thanks All,

If I want to get Last Six months of Data & In the Same way for previous year Same Six Months Data.

Comparison:

Last Six Months: Sep'13 to Feb'14

Last Year Six Months: Sep'12 to Feb'13

Regards,

Helen

[Anonymous]

Hi Helen,

You can retrieve record between specific dates using Set analysis and Script.

Implement master calender in script,its more flexible and user interval match() function.

Which gives more performance.

[#10]

Hi Helen,

Time chat wizard may help you. You can find it in tools menu. I am new to qlikview and may can't give an example.

thanks,

madhu