Visualization

Akshar — Wed, 10 Aug 2022 10:48:31 GMT

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.

Re: Visualization

justISO — Wed, 10 Aug 2022 11:17:13 GMT

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:

topic Visualization in App Development

Visualization

Re: Visualization