topic Re: where clause in expression in QlikView

where clause in expression

Thu, 27 Mar 2014 14:20:17 GMT

Hi,

I want to get field value based on filter criteria.

ex: field1value='A',get me field2

Earlier i used set analysis to get count

count({$<Type={'DUPLICATION'}>}ID)

Now i want just value of other field.if its of type duplication

Regards,

Prajna

Re: where clause in expression

MK_QSL — Thu, 27 Mar 2014 14:24:18 GMT

Can you provide some sample data?

Re: where clause in expression

Thu, 27 Mar 2014 14:27:17 GMT

Type Number

Establish 23

Testing 4

Duplication 45

Duplication 55

i want to shpw only duplication -number

Regards,

Prajna

Re: where clause in expression

MK_QSL — Thu, 27 Mar 2014 14:34:19 GMT

Temp:

Load * Inline

[

Type, Number

Establish, 23

Testing, 4

Duplication, 45

Duplication, 55

];

Join

Load Type, COUNT(Number) as Flag Resident Temp Group By Type;

NoConcatenate

Final:

Load * Resident Temp where Flag >1;

Drop Table Temp;

Re: where clause in expression

Thu, 27 Mar 2014 14:37:14 GMT

I want to achieve in expression.

I want to display number for type ='Duplication'

Regards,

Prajna

Re: where clause in expression

MK_QSL — Thu, 27 Mar 2014 14:40:20 GMT

Create a text box and type below...

=CONCAT(IF(Type = 'Duplication',Number),', ')

Re: where clause in expression

Thu, 27 Mar 2014 14:47:31 GMT

its giving me wrong data.

I have a table which holds type and number.

Regards,

prajna

Re: Re: where clause in expression

Anonymous — Thu, 27 Mar 2014 14:48:23 GMT

do you want to show Number field of Duplication type??

if yes,then you can refer the attached QVW for work around.

Hope it helps.

Re: where clause in expression

Thu, 27 Mar 2014 14:58:22 GMT

I want to show in bar chart . I have other dimesnions as well like clender values .Amount

Regards,

Prajna

Re: where clause in expression

MK_QSL — Thu, 27 Mar 2014 15:00:08 GMT

Can you provide us more sample data. It would be good idea rather than just guessing what you want.

Thanks..

Re: where clause in expression

Anonymous — Thu, 27 Mar 2014 15:06:58 GMT

It should have distinct dimension on which you can show the numbers and in set analysis, you can write Type as Duplication. It would be helpful to analyse if you can attach some sample document.