Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

where clause in expression


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

10 Replies
Highlighted
MVP
MVP

Re: where clause in expression

Can you provide some sample data?

Highlighted
Not applicable

Re: where clause in expression

Type                        Number

Establish                     23

Testing                         4

Duplication                    45

Duplication                    55

i want to shpw only duplication -number

Regards,

Prajna

Highlighted
MVP
MVP

Re: where clause in expression

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;

Highlighted
Not applicable

Re: where clause in expression

I want to achieve in expression.

I want to display number for type ='Duplication'

Regards,

Prajna

Highlighted
MVP
MVP

Re: where clause in expression

Create a text box and type below...

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

Highlighted
Not applicable

Re: where clause in expression

its giving me wrong data.

I have a table which holds type and number.

Regards,

prajna

Highlighted
subhasmita_kar
Contributor

Re: Re: where clause in expression

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.

Highlighted
Not applicable

Re: where clause in expression

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

Regards,

Prajna

Highlighted
MVP
MVP

Re: where clause in expression

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

Thanks..