Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mtabernad
Partner - Creator
Partner - Creator

Not showing current month

Hi all,

I want to show in a line chart the behavior of a KPI during the days of the current month. My expression is as follows:

 

=1+(

(count({$<flag_user={"$(='Sí')"},Month={"$(=max(Month))"},Year={"$(=max(Year))"}>}connect_time)
-
count({$<Month={"$(=max(Month))"},Year={"$(=max(Year))"}>}connect_time)

)
/
count({$<Month={"$(=max(Month))"},Year={"$(=max(Year))"}>}connect_time))

 

 

It works but only if a select the current month (november) in the filter pane, if not it shows up a  blank.

Without filters:

Screenshot at Nov 20 13-31-29.png

 

November selected:

Screenshot at Nov 20 13-31-08.png

So I want this last chart to show up without any selections.

 

Could anyone help me?

Thank you in advance.

Labels (3)
1 Solution

Accepted Solutions
forte
Partner - Creator
Partner - Creator

Hi @mtabernad 

It seems that you have value for December for "Month" field (may be due to master calendar). 

Just try changing your expression with something like this (calculating current month through today function)

 

=1+(

(count({$<flag_user={"$(='Sí')"},Month={"$(=month(Today()))"},Year={"$(=year(Today()))"}>}connect_time)
-
count({$<Month={"$(=month(Today()))"},Year={"$(=year(Today()))"}>}connect_time)

)
/
count({$<Month={"$(=month(Today()))"},Year={"$(=year(Today()))"}>}connect_time))

 

Hope it helps

Regards

View solution in original post

2 Replies
forte
Partner - Creator
Partner - Creator

Hi @mtabernad 

It seems that you have value for December for "Month" field (may be due to master calendar). 

Just try changing your expression with something like this (calculating current month through today function)

 

=1+(

(count({$<flag_user={"$(='Sí')"},Month={"$(=month(Today()))"},Year={"$(=year(Today()))"}>}connect_time)
-
count({$<Month={"$(=month(Today()))"},Year={"$(=year(Today()))"}>}connect_time)

)
/
count({$<Month={"$(=month(Today()))"},Year={"$(=year(Today()))"}>}connect_time))

 

Hope it helps

Regards

mtabernad
Partner - Creator
Partner - Creator
Author

Great Forte! It works!

Good workaround.

Thank you for your help. Regards.