topic Re: set analysis on line chart in QlikView

set analysis on line chart

Anonymous — Mon, 26 Oct 2015 04:49:34 GMT

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))

Re: set analysis on line chart

jsingh71 — Mon, 26 Oct 2015 04:57:47 GMT

Can you share sample data.

Re: set analysis on line chart

Anonymous — Mon, 26 Oct 2015 05:07:35 GMT

ID	Opendt	Closedt	Status
188497	30/09/2015 14:54	30/09/2015 14:54	Closed
188423	29/09/2015 10:52	30/09/2015 16:08	Closed
188422	29/09/2015 10:50	30/09/2015 16:09	Closed
188420	29/09/2015 10:46	30/09/2015 16:09	Closed
188415	29/09/2015 10:14	30/09/2015 15:57	Open
188391	28/09/2015 15:07	28/09/2015 15:08	Open
188390	28/09/2015 15:06	28/09/2015 15:07	Closed

Re: set analysis on line chart

ishanbhatt — Mon, 26 Oct 2015 05:19:33 GMT

Hi Suman Dhar,

If you are taking Status as List box for selection then below expression would be useful.

If(GetfieldSelection(Status)='Open',sum( {<Status = 'Open'>} 1),sum( {<Status = 'Close'>} 1).

Ishan Bhatt

Re: set analysis on line chart

jsingh71 — Mon, 26 Oct 2015 05:23:44 GMT

See the attached file.

If your requirement is something else then let me know.

Re: set analysis on line chart

ishanbhatt — Mon, 26 Oct 2015 05:23:52 GMT

Hi Suman Dhar,

If you are taking Status as List box for selection then below expression would be useful.

If(GetfieldSelections(Status)='Open',sum( {<Status = 'Open'>} 1),sum( {<Status = 'Close'>} 1).

Ishan Bhatt

Re: set analysis on line chart

Anonymous — Mon, 26 Oct 2015 05:28:32 GMT

Hi,

try this

set the variable vStatus

SUM({<Status={=$(vStatus)}>}1)

Re: set analysis on line chart

jagan — Mon, 26 Oct 2015 06:08:12 GMT

Hi Suman,

Use Status as dimension and use below expression

=Count(ID)

Hope this helps you.

Regards,

Jagan.

Re: set analysis on line chart

stephenedberkg — Mon, 26 Oct 2015 06:20:28 GMT

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

sum({<Status='Close'>} 1))

Re: set analysis on line chart

PradeepReddy — Mon, 26 Oct 2015 07:01:18 GMT

What is the dimension you are using for the chart..?

As of now, I can suggest

1) If you are using the status as dimension use Jagan's suggestion

2) If other dimension, take 2 expressions individually for each status and do a conditional enable

sum({<Status={'Closed'}>}1 ) --> Conditional enable it as getfieldselections(Status)='Closed'

sum({<Status={'Open'}>}1 ) --> Conditional enable it as getfieldselections(Status)='Open'

3) Otherwise take 2 dimensions, first one as Date field and second one as Status.

Take expression as Count(ID)

Re: set analysis on line chart

Mon, 26 Oct 2015 07:22:24 GMT

Thanks for everyone's help.

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

Re: set analysis on line chart

Anonymous — Mon, 26 Oct 2015 08:05:12 GMT

I have attached qvw file.

Please suggest.

Re: set analysis on line chart

PradeepReddy — Mon, 26 Oct 2015 08:15:11 GMT

see the attachment.. might be helpfull

Re: set analysis on line chart

jsingh71 — Mon, 26 Oct 2015 08:23:14 GMT

See attached qvw

Re: set analysis on line chart

Anonymous — Mon, 26 Oct 2015 09:10:23 GMT

Hi,

Thanks for your help.

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

Regrads

Re: set analysis on line chart

Anonymous — Mon, 26 Oct 2015 09:20:11 GMT

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.

Re: set analysis on line chart

PradeepReddy — Mon, 26 Oct 2015 09:31:22 GMT

see the attachment...

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

Re: set analysis on line chart

Anonymous — Mon, 26 Oct 2015 10:04:37 GMT

Jagan,

I have attached QVW application.

Please help.

Re: set analysis on line chart

Anonymous — Mon, 26 Oct 2015 10:19:41 GMT

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

Re: set analysis on line chart

PradeepReddy — Mon, 26 Oct 2015 10:38:22 GMT

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