Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Selected Dates Issue

I have a data set with ETL Date and Amount.  Requirement is that  when the user selects 2 different ETL Dates,  it should give me the below:

-Sum(ETL Date 1) - Sum( Etl Date 2)

-Sum(ETL Date 1)

/

Sum(ETL Date 2)

I used  the below expression to  get the difference between 2 selected dates but it works only for a straight table  with ETL Date as a Dimension.  I need expression which can give me the above 2 requirements even in a KPI  or Text Object.

Attached please find the sample app with the sample data

Rangesum(
Sum(Amount),
-Above(Sum(Amount))* Avg(1))

2 Replies
Highlighted
Partner
Partner

Re: Selected Dates Issue

Hi @Rehan ,

Got a bit confused regarding what you are trying to achieve. 

But if in the attachment, the scenario is:

>Select 2 dates
>Get the difference of both the days sales then,

Use this formula: 

=Sum({<[ETL Date] = {"$(=Max([ETL Date]))"}>}Amount)
-
Sum({<[ETL Date] = {"$(=Min([ETL Date]))"}>}Amount)

 

Attached the qvw for reference. let me know if there is some different expectation.

 

cheers!!!

AK

Highlighted
Creator II
Creator II

Re: Selected Dates Issue

I need the max and MIn date from the 2 selected dates not from the entire data set