Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

how to remove unwanted row from the table

Hello All,

i was able to achieve my requirement partial ,i got struck at one point ,  i want my list box should reflect only on one column,and based up on that column the other column values has to display , i mean this is my table when no selection had made in the list boxscreen2.png

to achieve this requirement for each column expression i added supcat= except column 3  ( which mean selection made on the listbox will not reflect those column except 3rd column expression )


expressions i wrote for each column



current self eval: FirstSortedValue(distinct {<ROLE={'SELF_EVAL'},SUPCAT=,MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)


auditor current :FirstSortedValue(distinct {<ROLE={'EVAL'},MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)

previous self eval: FirstSortedValue(distinct {<ROLE={'SELF_EVAL'},SUPCAT=,MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW,2)

previous current :FirstSortedValue(distinct {<ROLE={'EVAL'},SUPCAT=,MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW,2)

then i got what i am looking screen1.png


but the problem is Arvind Timber supplier whose Auditor current score is 83 which come under B+ i dont  want that  entire  row to be displayed when i select rating A







1 Solution

Accepted Solutions
Employee
Employee

Re: how to remove unwanted row from the table

Change all your expressions (excepct the second one) to something like this

if(Column(2)>0,FirstSortedValue(distinct {<ROLE={'SELF_EVAL'},SUPCAT=,MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW))

15 Replies
sureshqv
Esteemed Contributor III

Re: how to remove unwanted row from the table

hi,

chk in presentation tab hide column

kunkumnaveen
Contributor III

Re: how to remove unwanted row from the table

HI,

I think u havent understand my requirement , i am looking how to hide the column i am looking to hide the row that to dynamic

kunkumnaveen
Contributor III

Re: how to remove unwanted row from the table

HI,

I think u havent understand my requirement , i am not looking how to hide the column i am looking to hide the row that to dynamic

kunkumnaveen
Contributor III

Re: how to remove unwanted row from the table

Any suggestion or help regarding this requirement  plz

kunkumnaveen
Contributor III

Re: how to remove unwanted row from the table

Will it be ok if is use IF function, i mean

if(FirstSortedValue(distinct {<ROLE={'EVAL'},MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)='-','-',FirstSortedValue(distinct {<ROLE={'SELF_EVAL'},SUPCAT=,MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW))

which means if cloumn3 is null then rest column will be null,

then in table properties  if i enable  Suppress null values,i think the the row will be removed,

but the problem i am not able to write a proper if expression,can any one help how to this expression

Re: how to remove unwanted row from the table

Naveen - Would you be able to share your qvw file?

kunkumnaveen
Contributor III

Re: how to remove unwanted row from the table

plz just give me 5 min i   will do for you

thabang_petje
Contributor III

Re: how to remove unwanted row from the table

Hi,

Have you tried having a conditional statement where you define the expressions. Something like if(SUPCAT = 'A', 0, 1)

kunkumnaveen
Contributor III

Re: how to remove unwanted row from the table

please find the attachment

Community Browser