Flag for Pie chart

[soniasweety]

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.

[ankur_abhishek]

Hi Sony,

Please find the test qvw.

[srishsum2017]

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

[soniasweety]

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

[ankur_abhishek]

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)

[soniasweety]

thanks Abhi,

I will check and update you

[devarasu07]

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

[soniasweety]

thanks devarasu,

I will try this also

[soniasweety]

Hi,

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

[soniasweety]

And Age column is also giving wrong result

it is taking the year 1900