topic Re: Problem with dimension in QlikView

Problem with dimension

Fri, 20 Nov 2020 18:02:30 GMT

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 ?

Re: Problem with dimension

MK_QSL — Mon, 21 Jul 2014 09:37:48 GMT

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;

Re: Problem with dimension

Mon, 21 Jul 2014 09:41:25 GMT

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

Re: Problem with dimension

Jason_Michaelides — Mon, 21 Jul 2014 09:44:05 GMT

LOAD

Project,

Task

FROM Data....

WHERE Project <> 'C'

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

hope this helps,

Jason

Re: Problem with dimension

Anonymous — Mon, 21 Jul 2014 09:47:10 GMT

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.

Re: Problem with dimension

Jason_Michaelides — Mon, 21 Jul 2014 09:48:24 GMT

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

Re: Problem with dimension

amit_saini — Mon, 21 Jul 2014 09:52:16 GMT

Jakub,

Please see the attachment.

Thanks,

Re: Re: Problem with dimension

MK_QSL — Mon, 21 Jul 2014 09:53:57 GMT

Like this ?