Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
apegahfar
Contributor III
Contributor III

Subtract 2 expression

Hi Community

Is there any way to subtract two expression on one dimension?

For example:

I want to know how many personnel are decreased / increased base on 2017/01 or 2017/02 , .....

Regard

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like:

=Count([Personnel name])-Above(Count([Personnel name]))

Capture.PNG

View solution in original post

3 Replies
Anil_Babu_Samineni

May be this?

Count({<Date = {'2017-01','2017-02'}>}[Personnel name])

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
tresesco
MVP
MVP

May be like:

=Count([Personnel name])-Above(Count([Personnel name]))

Capture.PNG

apegahfar
Contributor III
Contributor III
Author

Dear Tresesco

thank for your reply

it work well

regard