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: 
ajinkyabhonsle
Contributor III
Contributor III

Restrict a value in dimenion for specific quarters

Hi Community,

I have the data in the below format in my database:

FiscalYearQuarterClassificationValue
2014/Q1Customer   9,798,799
2014/Q2Partner   7,689,909
2014/Q3ISV   8,797,997
2014/Q4Mobile   8,768,768
2015/Q1Customer   2,392,382
2015/Q2Partner   1,212,134
2015/Q3ISV   1,212,989
2015/Q4Customer   4,365,475
2016/Q1Partner   4,545,453
2016/Q2Mobile   3,424,323
2016/Q3Partner   6,454,322
2016/Q4ISV   4,564,234

I am using the set analysis in my measures field.
Sum({<CLASSIFIY = {'Customer','ISV', 'Partner'}>}METRIC_VALUE)

What I would like to do is to show the ISV Classification only till quarter 2015/Q4? Any thoughts on handling this?

 

1 Solution

Accepted Solutions
sunny_talwar

May be like this

Sum({<CLASSIFIY = {'Customer', 'Partner'}>+<CLASSIFIY = {'ISV'}, FiscalYearQuarter = {"2014*", "2015*"}>} METRIC_VALUE)

View solution in original post

1 Reply
sunny_talwar

May be like this

Sum({<CLASSIFIY = {'Customer', 'Partner'}>+<CLASSIFIY = {'ISV'}, FiscalYearQuarter = {"2014*", "2015*"}>} METRIC_VALUE)