Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ankurakash
Contributor III

Finding solution to $:: in Qlik Sense at expression level:

Hi Qlik Luminaries,

I am working on migration of QlikView app to Qlik Sense and currently facing challenge in replicating expressions from QV to QS. 

"$::" used in QlikView set analysis could be the reason as I don't see information around it while searching it for QS !! 

I would request support to help with solution or an alternative approach for a workable condition that I could proceed in Qlik Sense.

Sharing an example of the expression extract: 

ActiveCase=p({1<$(vDate), ActiveCase=$::ActiveCase>}Case)  

Is "$::" works in Qlik Sense !! If not, an alternative approach to meet the solution would be of great help !!

Thanks. 

Labels (5)
3 Replies
Digvijay_Singh

I don't see any documentation suggesting about any change with regard to $:: usage between Sense and Qlik view. As I know the calculation engine is exactly same for View and Sense so there shouldn't be any difference in the result of set expressions execution.

Can you share a sample to understand how this expression is difference between Qlikview and QlikSense?

 

Or
MVP

I haven't played around with it much, but I think you should be able to use e.g.

Sum({< Date=p({$}Date) >} [Amount])

To get the Date from the default state. How exactly this translates into more complex statements, I'm not entirely sure.

That said, I am not aware of changes to the previous syntax, though it does seem to be missing from the documentation. I ran a quick test and near as I can tell, $:: still works.

 

marcus_sommer

AFAIK this is related to: Using alternate states for comparative analysis ‒ Qlik Sense on Windows and is a method to connect different states within the set analysis. This means you would at first need to create these states before you could perform this measure.

- Marcus