topic Re: Re: how to show a staright table expression in a list box in QlikView

how to show a staright table expression in a list box

Wed, 10 Sep 2014 12:48:02 GMT

Hi all,

I have a straight table with 4 expressions and 3 dimensions and one of the expression (variance) having positive and negative values ,

my requirements is I need to create a list box as filter its should show 'positive' n 'negative' if user selects negative, only negative values should display in straight table and vice versa..

Thanks in advance

santhosh

Re: how to show a staright table expression in a list box

avinashelite — Wed, 10 Sep 2014 13:06:52 GMT

Hi Venkat,

Please find the attachment for the solution.

Re: how to show a staright table expression in a list box

israrkhan — Wed, 10 Sep 2014 13:29:32 GMT

you can do it, without list box...

go to your straight table properties>> presentation>> and select you expression and check searchable,

remember, the searchable option is available only for expressions, for dimension it is not available, but dropdownselect is available for dimension...see the image

and now you go to your table, you will see small icon for search, in your column...click it, you will see search box,

clear search box and type < 0 press enter, you will see only value are less than zero..for type > 0 for positive values..

see the image

hope it helps....

Re: how to show a staright table expression in a list box

Wed, 10 Sep 2014 13:56:47 GMT

Hi Israrkhan,

thanks for your quick reply and its is helpful, but I need to control negative values and positive values with list box .. do you have any idea..?

Re: how to show a staright table expression in a list box

Wed, 10 Sep 2014 14:28:15 GMT

Hi can you please send the attachment as I didn't get the attachment.

Re: how to show a staright table expression in a list box

israrkhan — Wed, 10 Sep 2014 14:30:31 GMT

I Think you try like....

Create a Inline table,

Table:

Load * INLINE [

ValueType

Positive

Negative

];

Than create a list box for this ValueType..now you will have two value is list boxas

Positive

Negative

and go to table expressions modify your expressions like

if(GetFieldSelection(ValueType) = 'Positive', if( VarianceColumn > 0, VarianceColumn , null) , if(GetFieldSelection(ValueType) = 'Negative', if(VarianceColumn < 0, VarianceColumn , null )))

and select suppress null values..

try some thing like...

it might help

or share the document, i will try to help...

Re: how to show a staright table expression in a list box

Anonymous — Wed, 10 Sep 2014 14:31:26 GMT

Hi Venkat,

pliz look at the image i have generated i have tested on the data u gave and seemed to work

the thing i did was to create an additional calculated field to the chart

let me know if it answers your question

Re: how to show a staright table expression in a list box

Wed, 10 Sep 2014 14:41:24 GMT

Hi please send me the attachment.

and do the needful

Re: Re: how to show a staright table expression in a list box

Anonymous — Wed, 10 Sep 2014 14:45:59 GMT

hi Ram i have attached the file

look at the file attached

Re: how to show a staright table expression in a list box

Wed, 17 Sep 2014 12:29:30 GMT

Hi Avinash,,

Thanks for you test file

its helpful but my scenario is I have a straight table with 5 dimensions and four expressions ,

one of the expression is giving all the positive and negative values,

now can filter those positive or negative values by using a list box...?

Venkat.

Re: how to show a staright table expression in a list box

Anonymous — Wed, 17 Sep 2014 12:34:30 GMT

Hi Venkat

did u have a look at the test file i sent u i had it working

Re: how to show a staright table expression in a list box

Wed, 17 Sep 2014 13:11:16 GMT

can you send me the attachment to venkata.terli@birlasoft.com

Re: how to show a staright table expression in a list box

Anonymous — Wed, 17 Sep 2014 13:15:15 GMT

i have emailed tou ur email u specified

Re: Re: how to show a staright table expression in a list box

sunilkumarqv — Wed, 17 Sep 2014 13:24:07 GMT

@Hi Venkat,

you can create one flag field which is what like for to identify the values positive or negative

so please kindly check and let me know so that we can find alternative

Re: Re: how to show a staright table expression in a list box

Anonymous — Wed, 17 Sep 2014 13:28:42 GMT

Hi Sunil i saw ur script but now lets bear in mind that the column is a calculated expression

have a look at the test app i sent

Re: how to show a staright table expression in a list box

Wed, 17 Sep 2014 13:43:14 GMT

Hi farai huruba,

Thanks for you test file

its helpful but my scenario is I have a straight table with 5 dimensions and four expressions , and the third expression =( Exp1-Exp2) this expression is giving all the positive and negative values,

now can filter those positive or negative values by using a list box...?

Venkat.

Re: how to show a staright table expression in a list box

sunilkumarqv — Wed, 17 Sep 2014 13:47:05 GMT

hi farai, i seen your expression that's good idea but even same Avinash r commented before, so i came with new idea.

Re: how to show a staright table expression in a list box

Wed, 17 Sep 2014 13:50:29 GMT

Hi sunil,,

what is that idea are you gng to share anything.

venakt

Re: how to show a staright table expression in a list box

sunilkumarqv — Wed, 17 Sep 2014 13:54:12 GMT

yaa i shared the attached file before look into that.

Re: how to show a staright table expression in a list box

Anonymous — Wed, 17 Sep 2014 14:04:00 GMT

Yes u can creat another calculated using this

if( Exp1-Exp2) <0,'-','+')

this will have a column with either "-" or "+"

then create a list box and use the expression