Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Roocha
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
juraj_misina
Luminary Alumni
Luminary Alumni

Hi,

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)

Roocha
Contributor II
Contributor II
Author

Thanks Juraj it worked