Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ankurakash
Contributor III
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
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