topic Re: Column heading in QlikView

Column heading

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hello eveyone,

it is possible ,when i select Negative(Red color) Value that time column name change to Loss and when i select Positive (Green color)Value then it change to profit.

Thank You.

Re: Column heading

Anil_Babu_Samineni — Wed, 15 Nov 2017 07:12:05 GMT

I never tried this before, Even don't have s/w to test. For a while my thought come up as

Below expression should be add for Label of expression with equal sign

=If(Measure < 0, 'Loss', If(Measure >0, 'Profit'))

Re: Column heading

tresB — Wed, 15 Nov 2017 07:21:31 GMT

In qlik, you can't select a figure/expression; you select a field value. If you click on a calculated number and see it is selected, you have actually selected a dimension value. By handling that selection you could probably write a conditional expression for dynamic label. Try to share your sample app to work upon for specific help in details.

Re: Column heading

satheshreddy — Wed, 15 Nov 2017 07:32:27 GMT

Hi Prachi,

it will work you have to write condition in exp lable box.

=If(Measure < 0, 'Loss', If(Measure >0, 'Profit')).

Regards

Sathish

Re: Column heading

Anil_Babu_Samineni — Wed, 15 Nov 2017 07:34:45 GMT

Have you tested? If so, Okay

Re: Column heading

satheshreddy — Wed, 15 Nov 2017 07:48:55 GMT

Hi Anil,

I had applied my application this long back.

Regards

Sathish

Re: Column heading

jyothish8807 — Wed, 15 Nov 2017 08:15:18 GMT

Hi Prachi,

Pfa sample.

Hope it helps.

Br,

Re: Column heading

Anonymous — Wed, 15 Nov 2017 08:20:34 GMT

yes i have ,its working but not properly.in some cases its shows profit or loss otherwise it shows -

Re: Column heading

Anonymous — Wed, 15 Nov 2017 08:22:06 GMT

i don't have license key, could you please share a screen shot.

Re: Column heading

jyothish8807 — Wed, 15 Nov 2017 08:25:33 GMT

Hi,

Script:

LOAD * INLINE [

Product, CP, SP

A, 100, 150

B, 100, 90

];

Then Create a straight chart.

Dimension: Product

Expression: CP-SP

Expression label: = if((CP-SP)<0,'Loss',if((CP-SP)>0,'Profit','Loss/Profit'))

You can replace "CP-SP" with your expression.

Br,

Re: Column heading

jyothish8807 — Wed, 15 Nov 2017 08:27:48 GMT

Re: Column heading

Anil_Babu_Samineni — Wed, 15 Nov 2017 09:32:25 GMT

That means, You could need this

=If(Measure < 0, 'Loss', If(Measure >0, 'Profit', 'Profit / Loss'))

Re: Column heading

Anonymous — Wed, 15 Nov 2017 10:12:31 GMT

i had tried but not working.

Re: Column heading

jyothish8807 — Wed, 15 Nov 2017 11:19:14 GMT

Can you share your application.

Br,