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: 
Anonymous
Not applicable

set analysis on line chart

in the line chart -if I want to click on open then list of records will dispaly on open condition and click on close then close records will diplay.

I want to do it using set anaylysis. Please help me construct the below expression.

IF( only(Status) = 'Open', sum( {<Status = 'Open'>} 1),  sum({<Status='Close'>} 1))

26 Replies
Not applicable
Author

Thanks for everyone's help.

Where could i write- getfieldselections(Status)='Closed'?

Anonymous
Not applicable
Author

I have attached qvw file.

Please suggest.

PradeepReddy
Specialist II
Specialist II

see the attachment.. might be  helpfull

jsingh71
Partner - Specialist
Partner - Specialist

See attached qvw

Anonymous
Not applicable
Author

Hi,

Thanks for your help.

If I click on the line graph(Open/Close) corrospong details will show on the straight table.

Regrads

Anonymous
Not applicable
Author

Thanks for your help.

My requirement is slightly different.

I have a line chart and straight table.

If i click on line chart then corroponding data will display on the table.

PradeepReddy
Specialist II
Specialist II

see the attachment...

If you click on the line(Open/close), the corresponding detailed data will appear in Straight Table

Anonymous
Not applicable
Author

Jagan,

I have attached QVW application.

Please help.

Anonymous
Not applicable
Author

It is working fine but if the ticket is not closed(open) it is also showing when you clicked on close.

PradeepReddy
Specialist II
Specialist II

can u elaborate the issue.. if possible attach the screen shot..