Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Set Analysis is not Working Propperly

Hi All,

I have a Date Filter and I want to make my set expression like this.

If we select Year = 2017, Month = March then we will have dates will be 1st March to 10 march.

If i select any date it will show value for till that date.

My expression is below:

Count({<DT={'=<$(v2)'}>}OrderLineDueCount).

But this is not working.

I am attaching my qvw file.

Could you please check and help to resolve.

Thanks,

Sarif

1 Solution

Accepted Solutions
sunny_talwar

Try this

=Count({<DT={'<=$(=$(v2))'}>}OrderLineDueCount)

View solution in original post

3 Replies
Anil_Babu_Samineni

65 MG is file size.. WOW

Count({<DT = {'$( '<=' & =Max(DT))'}, Year = {'$(=Max(Year))'}>} OrderLineDueCount)

Or

Count({<DT = {"<= $(=Max(DT))"}, Year = {'$(=Max(Year))'}>} OrderLineDueCount)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

Try this

=Count({<DT={'<=$(=$(v2))'}>}OrderLineDueCount)

View solution in original post