Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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
devarasu07
Master II
Master II

Hi,

It should work, can you share you app? .

may be you can try to apply date format in back end script and try again.

like this

Date([Open Date]) as [Open Date],

Date([Update Time]) as [Update Time],

Capture.JPG

soniasweety
Master
Master
Author

still the same issue 1900 year coming after changing the date format

devarasu07
Master II
Master II

Can you share your app?

soniasweety
Master
Master
Author

attaching sample app ,

check the age column values in my app

devarasu07
Master II
Master II

Hi,

check the attached,

note: back end script i've commented out few column it's not there in your uploaded source flag file

Capture.JPG

soniasweety
Master
Master
Author

still the same it is showing   

soniasweety
Master
Master
Author

what is the change I need to do in this?    I replaced the age column still same values showing in the filter

devarasu07
Master II
Master II

hi,

ServiceRequest:

load *, 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_Slab;

LOAD

    "Change ID",

    Category,

    "Sub-area",

    Status,

    "Assignment Group",

     date( "Open Date") as "Open Date",

     month([Open Date]) as Month,

     year([Open Date]) as Year,

     date([Open Date]) as Date,

     Day([Open Date]) As Day,

    round(now()-[Open Date],0.01) as TimeLefttoBreachSLA,

    Date([Close Time],'M/DD/YYYY') as [Close Time],

    Title,

    Assignee,

    Date([Update Time],'M/DD/YYYY') as [Update Time],

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

     "Update Actions",

    "SLA Breach"

FROM [lib://DataSource/Data\requests extract.xlsx]

(ooxml, embedded labels, table is cm3r1500445944654)

soniasweety
Master
Master
Author

still no use.

devarasu07
Master II
Master II

Hi,

Can you share your "requests extract.xlsx" file


do simple steps

1)

try to import your excel file into qliksense

2) add preceding load


like this,

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_Slab;    

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

load *

FROM [lib://DataSource/Data\requests extract.xlsx]

(ooxml, embedded labels, table is cm3r1500445944654)

Buckets

that's all.

thanks,deva