Problem with dimension

[#1]

Hi, I want to create a bar chart and my source data looks like presented below :

Project	Task
A	1
A	2
A	3
B	4
B	5
C	6
C	7

The problem is that from Project C i want just one Task '6' and i don't want to see others from this project.

Any idea how to do this ?

[MK_QSL]

Temp:

LOAD Project,

     Task

FROM

[http://community.qlik.com/thread/126410]

(html, codepage is 1252, embedded labels, table is @1)

Where Project <> 'C';

Concatenate

LOAD Project,

     Task

FROM

[http://community.qlik.com/thread/126410]

(html, codepage is 1252, embedded labels, table is @1)

Where Project = 'C' and Task = 6;

[#3]

Is there any way to do this not on a scrip level ?

[Jason_Michaelides]

LOAD

  Project,

  Task

FROM Data....

WHERE Project <> 'C'

OR (Project = 'C' AND Task = 6);

hope this helps,

Jason

[Anonymous]

Use a Calculated Dimension on your Chart :

=if ( not ( Project='C' and Task=7) , Project )

..and tick the 'Suppress When Value is Null' with this Calculated Dimension.

[Jason_Michaelides]

If you wanted to do this in the UI you should probably create a third field in the script that joins project and task, something like:

Project & ':' & Task AS ProjectTask

Then you can select the values you want and lock the field to exclude any tasks other than 6 for project C.

Hope this helps,

Jason

[amit_saini]

Jakub,

Please see the attachment.

Thanks,

[MK_QSL]

Like this ?