topic Re: Straight and pivot Table in QlikView

Color and Font style to Expression

Mon, 19 Jan 2015 11:26:56 GMT

Hi,

I have sum(Amounts) column as a Expression. My requirement is,

if sum(Amounts) has negative value , that negative value should be Red Color and that negative value in brackets like ( ).

How can i achieve this, could you please tell me Set expression and process

Thanks,

MLNR

Re: Straight and pivot Table

PrashantSangle — Mon, 19 Jan 2015 11:30:11 GMT

Hi,

Can you explain little bit more?

What is relation of sorting and input box.

Regards

Re: Straight and pivot Table

Mon, 19 Jan 2015 11:41:50 GMT

Hi,

I have straight and pivot table, in that i need to display Top N custno based on open amounts. and this openamount should be descending order. For this i created one variable , that variable passed to input box. By that input box i controlled those charts. Now in the same way i want to display all records.

How can i achieve.

Thanks

MLNR

Re: Straight and pivot Table

Mon, 19 Jan 2015 11:48:05 GMT

Hi,

To control the Top Records to be listed using Input Box. and along with that if user wants to display all the records.

what is process for that.

Thanks,

MLNR

Re: Straight and pivot Table

sasikanth — Mon, 19 Jan 2015 11:56:16 GMT

Create a seperate buttom for that and then give action to set a varible(input box varible)

set that to max number of records , so that it will display all the records

Re: Straight and pivot Table

Mon, 19 Jan 2015 12:04:29 GMT

Hi,

Thank you very much for your reply.

Can you tell me the steps to achieve this.

Explain more with Navigation.

Thanks,

MLNR

Re: Straight and pivot Table

sasikanth — Mon, 19 Jan 2015 12:55:25 GMT

create a variable for input box

suppose var1

then create a button add --> properties-->action-->set varible -->give variable name as var1-->

var value as count(ID) ( you can write pre-defined number also if you know the records like if 1000 are there then you can set to 10000) --> ok

give what ever you want in input box and then click the button if you want total reocrds

hope it helps you,

let me know if not