Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Getting all months gwrth value

Hi All,

Can anyone look here ,

I am getting all months with grwth 100% ...

Grwth Expression : ((Column(1)-column(2))/fabs(column(2))) *100

coming output :

Grwth.png

6 Replies
Anil_Babu_Samineni

If you don't have data For Column 1 and 2 then Qlik consider as 0 so then it will introduce 100% only. If not, You may provide more information

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
prma7799
Master III
Master III
Author

But in another chart it is showing only Apr data how it is possible then .

Is there any settings need to change in front end?

Please see the attached

Anil_Babu_Samineni

Yes, Go to dimension tab and Select month and give Suppress When value is null

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
prma7799
Master III
Master III
Author

I tried ...

But same gets appeared ...

Anil_Babu_Samineni

How values are looking when you use this? ((Column(1)-column(2))/fabs(column(2)))


Can you provide sample

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