topic Creating line chart staring from fourth date column in QlikView

Creating line chart staring from fourth date column

New-Qlik — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Creating line chart staring from fourth date column

narendiran — Fri, 22 Jul 2016 12:07:55 GMT

Hi Avneet,

Add Rowno() in load script

Load *, RowNo( ) as Rowno from Table;

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

Re: Creating line chart staring from fourth date column

sunny_talwar — Fri, 22 Jul 2016 12:10:24 GMT

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

Best,

Sunny

Re: Creating line chart staring from fourth date column

New-Qlik — Fri, 22 Jul 2016 12:30:09 GMT

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

Re: Creating line chart staring from fourth date column

New-Qlik — Fri, 22 Jul 2016 12:32:38 GMT

Please find sample data n graph

Re: Creating line chart staring from fourth date column

PrashantSangle — Fri, 22 Jul 2016 12:35:52 GMT

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,

Re: Creating line chart staring from fourth date column

New-Qlik — Fri, 22 Jul 2016 13:26:03 GMT

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

Re: Creating line chart staring from fourth date column

Anonymous — Fri, 22 Jul 2016 14:03:17 GMT

please find the attached

Re: Creating line chart staring from fourth date column

New-Qlik — Sat, 23 Jul 2016 03:44:50 GMT

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.

Re: Creating line chart staring from fourth date column

New-Qlik — Sat, 23 Jul 2016 10:51:59 GMT

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