Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qliker3
Creator
Creator

Ignore selection from filter pane in a scatter plot

Hi,

 

so i have a scatter plot and i want to ignore values selected in a fiter pane.

The field i want to ignore: "Part"

What i tried:

The x axis in scatter plot: 

sum( aggr( {<Part= >} [FCount], [SNr], Version, Name, Time, Path))

The y axis in scatter plot:

Aggr( {<Part= >} if(Duration <= Fractile({<Part = >} Total Duration, 0.99836), {<Part = >} Duration), [SNr], Version, Name, Time, Path)

And this dosent work.

Could you please help me with finding a solution? 

 

Thanks 

1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

=Aggr(Only({1} If(Duration <= Fractile(Total Duration, 0.99836), Duration)), [SNr], Version, Name,  Time, Path)

View solution in original post

4 Replies
BrunPierre
Partner - Master II
Partner - Master II

Try these:

=Sum({<Part=>} Aggr(Only({<Part= >} [FCount]), [SNr], Version, Name, Time, Path))

=Aggr(Only({1<If(Duration <= Fractile(Total Duration, 0.99836), Duration)), [SNr], Version, Name, Time, Path)

qliker3
Creator
Creator
Author

now it stopped working completely

qliker3
Creator
Creator
Author

where to close the "{" bracket? 

BrunPierre
Partner - Master II
Partner - Master II

=Aggr(Only({1} If(Duration <= Fractile(Total Duration, 0.99836), Duration)), [SNr], Version, Name,  Time, Path)