topic Re: Expression in straight chart in QlikView

Expression in straight chart

Sat, 15 Nov 2014 07:32:16 GMT

Hi!

I have created a straight chart using the following data:

ProjectID	ProjectStatus	Date
123456	Started	2014-01-01
123456	Underway	2014-02-01
123456	Finished	2014-03-01
234567	Started	2014-02-01
234567	Underway	2014-03-01

What I want to do is, I want this chart to show only ongoing Projects, in this case ProjectID 234567.

Re: Expression in straight chart

anbu1984 — Sat, 15 Nov 2014 07:44:28 GMT

Check this app

Re: Expression in straight chart

its_anandrjs — Sat, 15 Nov 2014 08:15:06 GMT

Hi,

Try this way

Tab1:

LOAD

ProjectID,ProjectStatus,

Date#(Date,'YYYY-MM-DD') As Date;

Load *Inline

[

ProjectID,ProjectStatus,Date

123456,Started,2014-01-01

123456,Underway,2014-02-01

123456,Finished,2014-03-01

234567,Started,2014-02-01

234567,Underway,2014-03-01

];

Left Join

LOAD

ProjectID,

Concat(ProjectStatus,',') as Details

Resident Tab1 Group By ProjectID;

And on the front end

Dim1:- ProjectStatus

Dim2:- Date

Dim3:- Details

Expre:- =if(Details = 'Started,Underway', ProjectID)

Regards

Anand

Re: Expression in straight chart

MK_QSL — Sat, 15 Nov 2014 08:25:57 GMT

Create a Straight Table

Dimension

Calculated Dimension

=Aggr(IF(SubStringCount(Concat(DISTINCT ProjectStatus,'|'),'Finished')=0,ProjectID),ProjectID)

2) ProjectStatus

3) Date

Expression

Go to Presentation Tab and Hide the Expression Column

Re: Expression in straight chart

its_anandrjs — Sat, 15 Nov 2014 08:34:03 GMT

Hi,

Or another without creating any field in the load script try this

On straight chart

Dim1:- =Aggr(if( Concat(ProjectStatus,',') = 'Started,Underway',ProjectID),ProjectID)

Note:- Suppress When Value is Null selected here

Dim2:- ProjectStatus

Expre:- Date

Regards,

Anand

Re: Expression in straight chart

Sat, 15 Nov 2014 09:03:25 GMT

Thank you!
This might work for my app,

Is there a way of making the ProjectID showing distinct?

Re: Expression in straight chart

its_anandrjs — Sat, 15 Nov 2014 13:22:54 GMT

Use DISTINCT key word otherwise i thing not required, if got the answer please close the thread with appropriate answer.

Regards,

Anand