Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
JohnSamuel123
Creator
Creator

Lock KPI chart that displays a formula

hi,

i can see a number of posts showing how to lock a visulsaition using {1} .

however im having trouble getting this to work on my formula:

='$(vMaxID) / $(vTotal)'

 

is it possible to lock the above formula so selections dont impact my vMaxID value?

thanks 

 

Labels (3)
1 Solution

Accepted Solutions
Lakshminarayanan_J

@JohnSamuel123 ,

Apologies for delay response , I missed you ping.

Please find the upload app with the expected result , for total you have used static value , let me know how it is getting calculated so that i will check and update on it as well

Thank You 

Lakshminarayanan J

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button

View solution in original post

9 Replies
Lakshminarayanan_J

@JohnSamuel123 

Can you post the variable expression ?

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
JohnSamuel123
Creator
Creator
Author

hi @Lakshminarayanan_J  vMaxID =max(ID)

vTotal is just a static number

Lakshminarayanan_J

@JohnSamuel123 .

Try using Alternate State for that KPI,

Go to Master Item -> Click on Alternatestate 

and create new alternate state like "test " .

Drag it to KPI which you need to Lock and click on Apply State

Once it applied , check on Alternate State ribbon on the KPI whether it is applied 

after that if any selection done it wont applied to that KPI

 

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
JohnSamuel123
Creator
Creator
Author

hi @Lakshminarayanan_J  i tried the above but the KPI is still changing when i do a selection:

my KPI:

JohnSamuel123_0-1659960630524.png

 

my assigned state master item:

JohnSamuel123_1-1659960663442.png

notice KPI change  once selection is made:

JohnSamuel123_2-1659960699947.png

 

Lakshminarayanan_J

@JohnSamuel123 

Kindly upload  sample app with limited data  in private  message .will work on it and share it back 

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
JohnSamuel123
Creator
Creator
Author

here is attached file with 2 lines of sample data

JohnSamuel123
Creator
Creator
Author

hi @Lakshminarayanan_J . did you have any luck with this? thanks

Lakshminarayanan_J

@JohnSamuel123 ,

Apologies for delay response , I missed you ping.

Please find the upload app with the expected result , for total you have used static value , let me know how it is getting calculated so that i will check and update on it as well

Thank You 

Lakshminarayanan J

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
JohnSamuel123
Creator
Creator
Author

thats perfect thanks a million Lakshminarayanan working great. the static value is currently updated manually monthly so i will just monitor that myself.

thanks for your help appreciate it