Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Qlik Community
- :
- Forums
- :
- Analytics
- :
- App Development
- :
- Re: need to distinct sum of volume for each ticket

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Swathi

Creator

2024-05-03
03:45 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

need to distinct sum of volume for each ticket

i have tktcode, material and volume, sales, material, i need to sum of distinct volume for each ticket.

for same tktcode i have several rows are there because material is different , but volume and sales willl be same for each tktcode.

if sum(volume), if will sum of all volume is 80, idealy it should be, volume should 35 ,. , now i need to write to take sum of distinct volume for each ticketcode, if two tktcodes have same volume, it should consider both volumes because tktcodes are different ,. kindly help me to to get sum of distict volume for each tktcode. i need that in kpi.

if i use sum( distinct volume), if will neglect volume if two different tktcode have same volume.

the formula it should interact with filters like some one slected some tkt codes, the formula should according to filter selction. it's very urgent kindly help me

tktcode | Material | Volume | Sales | materialcost |

1 | a | 10 | 20 | 10 |

1 | b | 10 | 20 | 20 |

1 | c | 10 | 20 | 30 |

2 | d | 10 | 30 | 30 |

2 | a | 10 | 30 | 20 |

3 | e | 15 | 30 | 23 |

3 | b | 15 | 30 | 21 |

6 Replies

BrunPierre

Partner - Master

2024-05-03
04:00 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Try

=Sum(Aggr(Only(Volume), tktcode))

296 Views

Swathi

Creator

2024-05-03
04:44 AM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@BrunPierre , Thanks for the reply, the above formula is working, same formula i need to adjust in below formula . can you pease help me with also, i new to qlik

(sum({1<MonthYear ={'$(vCurrentMonth)'} >}volume)

274 Views

BrunPierre

Partner - Master

2024-05-03
04:48 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

?

=Sum(Aggr(Only({1<MonthYear ={'$(vCurrentMonth)'}>} Volume), tktcode))

272 Views

Swathi

Creator

2024-05-03
05:47 AM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@BrunPierre , Thanks you reply, when iam using formula to YOY growth, iam not data, i used below formula. Kindly help me

(Sum(Aggr(Only({1<CYTD ={1}>} amount), tkt_code)) -Sum(Aggr(Only({1<PYTD ={1}>} amount), tkt_code))) /Sum(Aggr(Only({1<PYTD ={1}>} amount), tkt_code)),

262 Views

BrunPierre

Partner - Master

2024-05-03
09:42 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Swathi any responses might be based solely on assumptions, can you either share the app or post data and what you expect as outcome?

247 Views

Swathi

Creator

2024-05-03
10:06 AM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@BrunPierre ,it is giving 0%, but have some percentage difference, that is wrong.

even other place iam using below formula previously, iam getting current previous bubbles data

Sum({<Period,[MonthYear]={ ">=$(=(vMinYearMonth) )<=$(=(vMaxYearMonth) )" }>+

<Period,[MonthYear]={ ">=$(=(vLimitPrevious_Min) )<=$(=(vLimitPrevious_Max) )" }>} amount)

now i am using below formula it is giving only 2024 data currently, 2023 it is zero

Sum(Aggr(only({<[MonthYear]={ ">=$(=(vMinYearMonth) )<=$(=(vMaxYearMonth) )" }>}amount),tkt_code))+

Sum(Aggr(only({<[MonthYear]={ ">=$(=(vLimitPrevious_Min) )<=$(=(vLimitPrevious_Max) )" }>}amount),tkt_code))

Kindly check these

243 Views

Community Browser