Creating line chart staring from fourth date column

[New-Qlik]

Hello ,

I have to create a line chart in which my x axis should start from fourth record (date column)

I tired using dimension as (if(rowno() >4 , date)

but it is not working because data inserted into tables is in different sequence and we are displaing in different.

please find attached smaple data along with chart which needs to be build.

Kindly let me know if it makes any sense.

Thanks

[narendiran]

Hi Avneet,

Add Rowno() in load script

Like

Load *, RowNo( )  as Rowno from Table;

then use the same if(rowno() >4 , date)

[sunny_talwar]

Do you have a sample you can share with the expected output to help you better.

Best,

Sunny

[New-Qlik]

Thanks .. But I cannot put rowno because example

Rowno   Date

1        2016030801(yyymmddhh)

2        2016030709

3         2016022604

4       2016022618

5      2016022610

6     2016022600

7     2016022601

8   2016022605

etc.. so if I want to start building graph it will start with 2016022600 but I want to start it with 4th record so it will be

2016022605( how if u sort it it will come as 2016022600,2016022601,2016022604,2016022605,2016022610,2016022600,2016022618.....)

so I want to sort date and pick up fourth record and give date interval as 4.

I hope I have explained it properly

[New-Qlik]

Please find sample data n graph

[PrashantSangle]

attachment missing...

well logic could be in set analysis expression you can use

min(date,4) and max(date)

like sum({<date={">=$(=date(min(date,4)))"}>}sales)

Regards,

[New-Qlik]

Thanks for replying.

I am using line chart-->dimension is Date-->edit dimension-->=mim(Date,4)

its says expression ok but chart is displaying no data

[Anonymous]

please find the attached

[New-Qlik]

Thanks Vinay really appreciate,

But I have personal edition so cant open your qvw. If you can post what needs to be done that will be big help.

[New-Qlik]

I tried same

dim is = [Christian Full Date

expression =sum({<[Christian Full Date]={">=$(=[Christian Full Date](min([Christian Full Date],4)))"}>}Qty)

but its starting from 2016022600 only