Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
balrammahato204
Creator
Creator

Set Expression not working on qliksense

Hi All,

Below set analysis is working on qlikview on current selection of date providing the MTD data, But same expression is not working on Qliksense. Pleae help me if i am doing anything wrong.

=Count(Distinct {<Date={">=$(=$(vMonthStart)) <=$(=$(vCurrentDate))"}, FIS_YEAR=, FIS_MONTH_NUM=,MissDate=>}MISS_ID)

 

Thanks  in Advance

Balram

Labels (1)
2 Solutions

Accepted Solutions
sunny_talwar

It could be because of many reasons... here can be some of them

1) Do you have the variables set up?

2) Do you have the variables set up in correct way?

3) Are the date formats same in both QlikView and Qlik Sense (Formats play a big role in set analysis syntax)

View solution in original post

balrammahato204
Creator
Creator
Author

Thanks Sunny,

I have resolved the issue.

Regards

Balram

View solution in original post

3 Replies
anushree1
Specialist II
Specialist II

Sample application would be helpful to check on this case

 

sunny_talwar

It could be because of many reasons... here can be some of them

1) Do you have the variables set up?

2) Do you have the variables set up in correct way?

3) Are the date formats same in both QlikView and Qlik Sense (Formats play a big role in set analysis syntax)

balrammahato204
Creator
Creator
Author

Thanks Sunny,

I have resolved the issue.

Regards

Balram