Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

how to create new report from two existing chart expressions in application

Hello All,

Please help me with below scenario were i have 2 charts with different expressions.

diff of expression.PNG

status A Expression - =MaxString({< [Default Status] = {$(VcnStatusA)}, Date = {">=$(=min(StatusA_From_Date))<= $(=max(StatusA_To_Date))"}>}CN)

Status B Expression =MaxString({< [Default Status] = {$(VcnStatusB)}, Date = {">=$(=min(StatusB_From_Date))<= $(=max(StatusB_To_Date))"}>}CN)

output what i want to display in different report is CN's which fall under difference of date range selected for both the above charts.

Thanks in Advance

2 Replies
Luminary Alumni
Luminary Alumni


you can use standard set operations, so you can as well calculate difference between sets:

MaxString({< [Default Status] = {$(VcnStatusA)}, Date = {">=$(=min(StatusA_From_Date))<= $(=max(StatusA_To_Date))"}-{">=$(=min(StatusB_From_Date))<= $(=max(StatusB_To_Date))"}>}CN)

Contributor II
Contributor II

Thanks Juraj it worked