Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
suryajeganathan
New Contributor III

How to use two identifiers in one set analysis

Hi


I am trying to use two identifiers in one set analysis.


In the below case i dint want my formula to consider Type Field that i mentioned like 1<TYPE= & remaining fields has to be considered

ex country_name,ww_segment etc.


How to achieve this?



(SUM({1<TYPE=,fiscal_quarter=,week_start ={">=$(=date(QuarterStart(Max(week_start)))) <=$(=date(AddYears(Max(week_start))))"}

,country_name,ww_segment=,bpc_segment_description=,geography

>}accessories_revenue_yoy)


Tags (1)
8 Replies
YoussefBelloum
Esteemed Contributor

Re: How to use two identifiers in one set analysis

Hi,

you already removed Type field by using this: TYPE=

to consider country_name and vw_segment, just remove them from the set analysis.

or I'm missing something ?

suryajeganathan
New Contributor III

Re: How to use two identifiers in one set analysis

If i am removing those fields (country_name ,ww_segment) from the set analysis . The data is get filtered out if i select the country_name & ww_segment filter

That is my issue...

suryajeganathan
New Contributor III

Re: How to use two identifiers in one set analysis

If i am removing those fields (country_name ,ww_segment) from the set analysis . The data is not getting filtered out if i select the country_name & ww_segment filter

That is my issue...

Re: How to use two identifiers in one set analysis

What exactly do you mean when you say "remaining fields has to be considered"? It seemed that you wanted to allow selection in those fields... but thne you said "The data is get filtered out if i select the country_name & ww_segment filter"? I would have thought that being considered means that you allow for selections

suryajeganathan
New Contributor III

Re: How to use two identifiers in one set analysis

Hi Sunny

Sorry for the confusion.

TYPE - I don't want to allow the selection that is already achieved in my above expression

But wen the user selects country_name & ww_segment the expression should allow the selection and the data in the dashboard shld get filtered out accordingly

If i remove those field(country_name & ww_segment) from the set analysis its not happening. So how to achieve?

suryajeganathan
New Contributor III

Re: How to use two identifiers in one set analysis

Hi Guys

i changed my expression like below

SUM({1<TYPE,fiscal_quarter=$::fiscal_quarter,geography=$::geography,country_name=$::country_name,ww_segment=$::ww_segment,bpc_segment_description=$::bpc_segment_description>}


ship_accessories_revenue)


The data is getting filtered out ... But the Measure Values are coming wrong...I dont know why


Can any help me ?

Re: How to use two identifiers in one set analysis

You need to remove 1 from your expression also

suryajeganathan
New Contributor III

Re: How to use two identifiers in one set analysis

below mentioned expression is working fyn...Tanq all for ur help


SUM({<TYPE>}


ship_accessories_revenue)