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: 
panipat1990
Creator II
Creator II

Set Syntax in qliksense

Dear Team,

I stuck  a issue.when i am using Set Syntax in qliksense. My Result is not Showing According.But Same Expression is going on qlikview. Kindly help me. Actually i am finding MTD SALE. And using this Expression

=Sum({$<Link_Date={"<=$(vCurrentDate)>=$(vMonthStart)"},[FY Year Name],[Fiscal Quarter],[Fiscal Month]>} Net_Value)

What's the reason behind it.Why this expression not running,

2 Replies
sunny_talwar

Have you checked your variables? Also, the Link_Date might have different format in QlikView vs. Qlik Sense?

panipat1990
Creator II
Creator II
Author

Dear Sunny,

  When i make a report in qliksense. Suppose Product wise sale Total is 600.But when i export to excel then it doesnot show 600 in qliksense.How is it possible in qliksense.