Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
tan_chungkam
Contributor

Re: Remove or Replace Null Values

@cpomeren003 ,

Really thank you for your prompt reply.

Then i would have to ask how to do it in scripting? 

Sorry for keep asking.

Partner
Partner

Re: Remove or Replace Null Values

Unfortunately I don't have time to do it atm (maybe in 8 hours when I am off work).

In theory how I would do it:
1. Find lowest/min date in Start Date
2. Find highest/max date in End Date
3. Make a row with Calendar | lowest Start date | highest end date
4. Concatenate with imported Excel
5. Celebrate

Try it yourself or wait till I return from work.
tan_chungkam
Contributor

Re: Remove or Replace Null Values

Hi @cpomeren003 ,

I had tried.

It work perfectly.

However that is another problem come to Sorting.

The date doesn't sort Jan>Feb>Mar......

Any idea what happen?

Please find attached my qvf file.

Partner
Partner

Re: Remove or Replace Null Values

Good to hear you succeeded!

Try this for your new problem:

1) Go to sorting inside your chart;
2) Drag "Date" to the top;
3) Only enable "Sort numerically";
4) Set it to ascending;

Qlik1.PNG
Hope this helps.

Highlighted
tan_chungkam
Contributor

Re: Remove or Replace Null Values

Hi @cpomeren003 ,

Hope u had a good holiday yesterday.

My pivot table having sort problem instead of the straight table.

I guess something goes wrong in my scripting.

Thank you for your great effort.