Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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: