Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

Re: greater than value

Hi Sony,

Try this script:

Data:

Load

*,

if(Name='3Build',sign(Duration - 3),if(Name='5Build',sign(Duration - 7),1)) as CondShow;

LOAD * Inline [

ReNum,Name,Duration

A1,3Build,1.2

A2,3Build,2.2

A3,3Build,3.5

A4,3Build,4.5

A5,5Build,6.7

A6,5Build,7.6

A7,5Build,8.6

A8,5Build,5.4

A9,ARP,22.1

A10,DRP,33.1

A11,CRP,23.4

];

Create a straight table with dimensions ReNum, Name and Duration.

Add this expression:

if(not isnull(GetCurrentSelections('|')),

CondShow + if(Wildmatch('$(=GetCurrentSelections('|'))','*' & Name & '*'),1,0),1)

You can hide this expression column.

In the Presentation tab check Suppress Zero Values.

It's a bit messy but seems to give you what you need.

Cheers

Andrew

PS

If you don't want to change your script use this expression instead

if(not isnull(GetCurrentSelections('|')),

if(Name='3Build',sign(Duration - 3),if(Name='5Build',sign(Duration - 7),1)) + if(Wildmatch('$(=GetCurrentSelections('|'))','*' & Name & '*'),1,0),1)

Highlighted
Specialist III
Specialist III

Re: greater than value

thanks for your response.

Andrew Walker

but I have 20dimensions and one measure.  I don't know why it is not working.

but I  created separate table for full data and  for 3build one table and 5build other table.

used below exp

=count({<[name]={'5Build'},[Duration]={'>7'}>}[Renum])

and

=count({<[name]={'3Build'},[Duration]={'>3'}>}[Renum])