Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Prabhu
New Contributor III

Data filtering in chart

Hi,

I want to filter the data  for each Date based on maximum value of Issue Type field.

I have data like this:

DateIssue Typeresolution time
4/12/2019123
4/12/2019256
4/13/2019234
4/13/2019478

 

I want to show in a  chart like this:

DateIssue Typeresolution time
4/12/2019256
4/13/2019478

 

@sunny_talwar , @maxgro 

Tags (2)
3 Replies

Re: Data filtering in chart

Try this

Dimension

Date

Expression

Max([Issue Type])
FirstSortedValue([resolution time], -[Issue Type])
Prabhu
New Contributor III

Re: Data filtering in chart

Hi Sunny,

The second expression is working. But, is there any way to show "issue type" value as pop up or legend?

Re: Data filtering in chart

I am not sure I follow your question?