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: 
vijetas42
Specialist
Specialist

conditional display

Hi, In chart I want to enable expression only for year which is not having whole 12 months data how can I write expression?

2 Replies
amit_saini
Master III
Master III

Hi Vijeta,

You can exclude suppose for example Year 2014 in set analysis expression by using -= like below

=Sum({<Year-={2014}>} Sales)

Thanks,

AS

sundarakumar
Specialist II
Specialist II

From what i understood is, u have data year and month wise.. u need to show data year wise with a condition that the year dont have data for all the 12 months..

groupd by data by year and count the number of months available for all years..

then set a flag for the years that dont have data for all 12 months all the above steps in script.

Then in ui write a calculated dimension or set alternate state to show only years that have a flag..

If this is now what u require, pls explain..

-Sundar