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: 
giovanni_mezzap
Contributor
Contributor

How to use a formula as the dynamic limit for conditional color in KPI

Hello to all!

I am a new user of Qlik Sense.

I have created a KPI for current month compared to last month and now I want to use as the dynamic limit for conditional color the value of last month (using the last month formula), but the value is the sum of all value.

what am I doing wrong?  

These are the formulas:

current month: Sum( { $< [Date / EndTest.autoCalendar.InMTD]={1}, [Date / EndTest.autoCalendar.MonthsAgo]={0} > } [Number of Tests] )

last month: Sum( { $< [Date / EndTest.autoCalendar.InMTD]={1}, [Date / EndTest.autoCalendar.MonthsAgo]={1} > } [Number of Tests] )

2 Replies
shraddha_g
Partner - Master III
Partner - Master III

If possible share sample app

shraddha_g
Partner - Master III
Partner - Master III

I guess for Last Month it should be

Sum( { $< [Date / EndTest.autoCalendar.InMTD]={0}, [Date / EndTest.autoCalendar.MonthsAgo]={1} > } [Number of Tests] )