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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)