Hello. I've been researching how to get a field selection count for various fields in various alternatestates and am not really seeing how to execute the formula. I've tried different things b...
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...
...eopleCount'},JobType=>} [Count In]) now instead of creating a new variable with the alternatestate like that sum ({Group2<H_Flag={'PeopleCount'},JobType=>} [Count In]) i w...
...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...
Hello, i need to use use alternatestates in dimensions or alternatively without an operation like sum, count,etc.. Is it Possible? Thanks in advance, Regards
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...
Hello, I'm new with alternatestates. It's possible to use alternatestates (ie use Group1) with a set analysis syntax as below? Can you give a sample please? =Count({$<MonthID = {"&l...
...ort of dollar-sign expansion that I don't understand. In the Qlik help doc for Examples of AlternateStates in Chart Expressions there is the following example : count({State1<Y...
...oxes and within that I have the following two expressions: 1. =count({$<Year = p({State1}Year)>} DISTINCT [Invoice Number]) and 2. =count({$<Year = State1::Year>} DISTINCT [Invoice N...