How to divide a groups based on the records

[rkpatelqlikview]

Hi,

Can anyone please help to write the backend code for this scenario?

I have table which is having the stores and sales. I need to divide three groups.

Group1 is 0-100 sales, Group2 is 100-300 sales, above 300 sales - Group3.

How many vehicles having for each group.

I need to show group1 stores and groip2 and group3 stores in the list box and pie chart.

Thanks in advance.

[rkpatelqlikview]

Many Thanks Youssef,

After writing the below script , Its showing below.

CurrentFleet:

mapping LOAD

//[Vehicle Number],

SubField([Vehicle Number],'(',-1) as [Vehicle Number],

    //[DEVICE NO],

    Date(STATUS) as STATUS

FROM

;

Load *,

if([Vehicle Number]<100,'Group1',if([Vehicle Number]>100 and [Vehicle Number]<300,'Group2','Group3')) as Group;

SND:

LOAD

Date(Date) AS Date,

    Plant,

    ApplyMap('CurrentFleet', [Vehicle Number],'N/A') as STATUS,

    [Carrier Code],

    [Carrier Name] AS [Transporter Name],

    [Vehicle Group],

    // [Vehicle Number],

    SubField([Vehicle Number],'(',-1) as [Vehicle Number],

    [LR Number],

(ooxml, embedded labels, table is Sheet1);

[YoussefBelloum]

My bad, try this:

SubField([Vehicle Number],'(',1) as [Vehicle Number]

[rkpatelqlikview]

No Problem Youssef,

I tried with this. Getting like below

[YoussefBelloum]

Make sure you use the correct modified field,

you should have this:

[rkpatelqlikview]

Thanks Youssef,

Really am very sorry. Can you please check with this application?

Thanks

KUMAR

kumardeveloper19@gmail.com

[YoussefBelloum]

Done !

here is the result with =SubField([Vehicle Number],'(',1) on the right object

PS: I do it on the object, because i can't reload your app (don't have the data)

[rkpatelqlikview]

Yes Youssef, Thanks its working in the frontend. When i written in the back end its not worked properly.

Many Thanks

[YoussefBelloum]

You're welcome but It should work !

Read this for more informations

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/StringFunctions/Sub...