Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Flag for Pie chart

Hi all,

Tresesco B

I want to create a pie chart  with the bucket values like below

0-7 days

7-14 days

14-30 days

30-60 days

so I want this from  "updated date column"

I don't have master calendar . And I need result in days.

19 Replies
Highlighted
Contributor III
Contributor III

Hi Sony,

Please find the test qvw.

Capture.JPG

Highlighted
Creator
Creator

Hi Sony, download this qvw file and try the steps it will automatic convert it into qvf

A QVW to QVF Conversion That Makes Sense | Analytics8

https://help.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/LoadData/create-app-from-document.htm

Sumit Kumar Srivastava
Highlighted
Specialist III
Specialist III

I need only  specified range only.  if I use above its givng more range

Highlighted
Contributor III
Contributor III

Hi Sony,

I have mentioned below the qlikview script.

LOAD ID,

     Category,

     [Open Date],

     [Close Time],

     Assgn,

     [Update Time],

     Breach,

     Interval([Update Time]-[Open Date],'d')as Interval_date

FROM

(ooxml, embedded labels, table is Sheet1);

In dimension use for specific range as per your requirement:

=if(Interval_date<7,'0-7 days', if(Interval_date >7 and Interval_date < 14,'7-14 days', if(Interval_date >14 and Interval_date < 30,'14-30 days',if(Interval_date <60 and Interval_date  >30,'30-60 days' ))))

In Expression use: count(Interval_date)

Capture.JPG

Highlighted
Specialist III
Specialist III

thanks Abhi,

I will check and update you

Highlighted
Master II
Master II

Hi,

you can try like this,

Fact:

load *, if( (age) = 0, '0',

    if( (age) >=0 and (age) <7 , '0-7 days',

    if( (age) >=7 and (age) <14, '7-14 days',

    if( (age) >=14 and (age) <30, '14-30 days',

        if( (age) >=30 and (age) <60, '30-60 days'))))) as aging_bucket;     

LOAD ID,

     Category,

     [Open Date],

     [Close Time],

     Assgn,

     [Update Time],

     Breach,

     Interval([Update Time]-[Open Date],'dd') as age

    

FROM

(ooxml, embedded labels, table is Sheet1);

Highlighted
Specialist III
Specialist III

thanks devarasu,

I will try this also

Highlighted
Specialist III
Specialist III

Hi,

I want to show by status  but it is givng me wrong

st_pie.PNG

Highlighted
Specialist III
Specialist III

And Age column is also giving wrong result

it is taking the year 1900

190.png