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: 
surajap123
Creator II
Creator II

expression help

Hi Experts,

I have data for 4 months(Jan to Apr)

I want to create an expression that show if Apr-2012 percentage is greater than Jan-2012. If there is no data available in Jan then take feb and so on.

eg- For Product Sub-Category- 'Office Furnishings' there is no Jan data, so pick the Feb. Similarly 'Bookcases' don't have Apr data, so pick March data.


image.png

Please help!

4 Replies
Anil_Babu_Samineni

Why not these?

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vinieme12
Champion III
Champion III

Hi Suraj,

Q1) What if you have Data for Jan,Feb and April but not for March?

For Jan you want to look forward and for April you want to look backward what about the months in the middle?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

Amazing question ... I was wondering the same thing

surajap123
Creator II
Creator II
Author

sorry, i myself not clear with the requiremen.

I Actually want to check percentage increase or decrease between each month-year.

so between each month i want to show GREEN  color when current month is more than previous, otherwise show red color in a new column.

Thanks!