Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Akshar
Contributor
Contributor

Visualization

Hello One and All

I am trying to develop an app where I want a visualization in the form of a Bar chart. The data contains Column A which is the expected arrival date and Column B is the current date.

The Bar chart will show only overdue counts with <5 days due, 5-10 days due, and 10+ days due. The purpose is to understand the breakup of overdue in terms of days difference and compared with a current date. So it will be a dynamic visualization. 

I am not sure how to do this as I am a beginner at Qlik. The sample data is attached herewith. 

Labels (1)
1 Reply
justISO
Specialist
Specialist

Hi, you can modify a bit your load script to get already calculated fields for easier work. For example, [Current Date] field (or column B as you call) you can make directly (and dynamically) with today() function. So your load script could look like this:

LOAD
    A as [Expected Date],
    today() as [Current Date], //instead of just [Current Date] or columnB dimension
    A-today() as DifferenceInDays, //calculate difference between dates in dayes
    if( (today()-A)<5, '<5 days due', 
    	if((today()-A)>=5 and (today()-A)<10, '5-10 days due', 
        if((today()-A)>=10, '+10 days due'))) as dueDays
FROM [lib://AttachedFiles/Qlik Data.xlsx](ooxml, embedded labels, table is Data);

If needed, you can modify it according your needs. Now on report level you just create your bar chart from needed objects and measures something like this:

justISO_0-1660130225297.png