Hello,
I'm using an alternatestate and want to filter in set analysis to the possible customer ids (CID) for the selected field in the alternatestate:
count({<CID=P({<Product=[ALT State...
Hi All, I am fairly new to Qlik Sense and I was wondering whether it was possible to predifine a filter in a measure, but only is applied when a AlternateState is applied. I am looking to a...
...ggr(only({[State A] + [State B]} FORECASTID),FORECASTID)
This works great and I can make a simple count of a field 'IDCONTRACT' or whatever measure:
What I want to do is split up in 4 l...
I have two alternatestates: C1 and C2.
I have two filters, both of which use the same dimension: [Sold Month Year] - which is a monthname([Sold Date]) in the data load editor. I apply C1 a...
Hey Qlik Sense Community, reaching out because I am at the end of my rope with a particular problem. In a KPI object in an alternatestate, I am attempting to count all possible encounter numbers o...
I'm using two alternatestates (Left and Right) to compare two periods. In my expression I want to derive the number of new customers where the previous period is in alternatestate Left. The l...
Hi All, I have created alternatestates Group 1 ,Group 2 and assigned to below expression but the result return is zero count Appreciate can any one help me out for expression &n...
...as State1. 3. Third filter is dedicated to 2nd kpi chart of alternatestate as State2 And a KPI chart of expression: Count(distinct TicketID) How do I brinng 1.both 1st filter and 2...
Hi,
I have created two alternatestates on the sheet, created separate measures for each state following the same schema:
COUNT({[AlternateState1]}{1<[ConditionField]={'ConditionValue'}>}[F...
