Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

within of current month until today

Hi Folks, 

i got a question, i am bit struggling with following issue, my data do look like:

test:
load * Inline [
MyData, Turnover
28.05.2021, 9
01.06.2021, 1
05.06.2021, 2
12.06.2021, 3
14.06.2021, 4
15.06.2021, 5
16.06.2021, 6
17.06.2021, 7
01.07.2021, 8
];

 

my issue is, how can i show the data of curren month but until today:

my expeceted output is:  Sum(Turnover) = 10 , i am using this expression:

Sum({<Month = {"$(=Month(Today()))"}>}Turnover), but i receive the whole  Turnover.

 

Does anybody have any idea how to rectify this issue?

Thanks a lot

Bek

 

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like below

Sum({<MyData = {">=$(=MonthStart(Today()))<=$(=Today())"}>}Turnover)

MayilVahanan_0-1623662607566.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

2 Replies
MayilVahanan

Hi

Try like below

Sum({<MyData = {">=$(=MonthStart(Today()))<=$(=Today())"}>}Turnover)

MayilVahanan_0-1623662607566.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

beck_bakytbek
Master
Master
Author

Hi Mayil Vahanan R,

 

thanks a lot for your valuable time and your help