Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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