topic Re: How to use between case in Conditional formatting in QlikView

How to use between case in Conditional formatting

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

Hi All,

I want to mark background color with yellow color if percentage falls between 40% to 60%.

Please help me that how can i do the same. Below is the screenshot.

Re: How to use between case in Conditional formatting

Anil_Babu_Samineni — Sun, 17 Dec 2017 10:29:21 GMT

Use 0.6 ??

Re: How to use between case in Conditional formatting

martinpohl — Sun, 17 Dec 2017 10:45:20 GMT

on the visualtion tab you can only use one limit.

go to tab expressions, collaps the + in front of the third expression, select background color

there you can use:

if [Percentage%] >= 0.4 and [Percentage%] <= 0.6,yellow())

although there is a Statement that Percentage% is a unknown field this works, but be sure that expression label is case sensitive and remember spaces

regards

Re: How to use between case in Conditional formatting

bhuprakash — Sun, 17 Dec 2017 10:56:01 GMT

OK.. Let me try

Re: How to use between case in Conditional formatting

bhuprakash — Sun, 17 Dec 2017 11:06:17 GMT

Hi Martin, This is working but only for particular cell. Is it possible to color complete row if the condition is true.

Re: How to use between case in Conditional formatting

martinpohl — Sun, 17 Dec 2017 11:09:24 GMT

so you have to copy the background expression to every expression and dimension

Re: How to use between case in Conditional formatting

bhuprakash — Sun, 17 Dec 2017 11:09:31 GMT

And also please tell me that how can i sort Percentage(%) in Descending order. Because there is option Y- Value but it is sorting Total_Employee.

Re: How to use between case in Conditional formatting

bhuprakash — Sun, 17 Dec 2017 14:54:41 GMT

any suggestion on the same ?

Re: How to use between case in Conditional formatting

Anil_Babu_Samineni — Sun, 17 Dec 2017 15:29:13 GMT

You said, You will get back. I thought you already got output. Anyway, Will you provide mock application to investigate?

Re: How to use between case in Conditional formatting

bhuprakash — Sun, 17 Dec 2017 15:40:35 GMT

Dear Anil,

Color formatting issue is resolved. I want to sort the data using Percentage(%) column.

Also I want to subtract Percentage from First table - Percentage from Second table

Please let me know how to attached .qvw file so that i can send u.

Re: How to use between case in Conditional formatting

Anil_Babu_Samineni — Sun, 17 Dec 2017 15:42:54 GMT

Uploading a Sample

POS - Try to start subsequent content ..

Re: How to use between case in Conditional formatting

bhuprakash — Sun, 17 Dec 2017 15:51:03 GMT

Please find the attached file.

Re: How to use between case in Conditional formatting

Anil_Babu_Samineni — Sun, 17 Dec 2017 16:12:50 GMT

PFA

Re: How to use between case in Conditional formatting

bhuprakash — Sun, 17 Dec 2017 16:51:13 GMT

Thanks Anil for help.

This is very helpful for me for future. My requirement is bit change as i want to subtract Percentage from

Table1-table2

Also want sort the table data by Percentage.

Please help in the same as well.

Re: How to use between case in Conditional formatting

Anil_Babu_Samineni — Mon, 18 Dec 2017 01:51:39 GMT

PFA of V1

Re: How to use between case in Conditional formatting

bhuprakash — Mon, 18 Dec 2017 06:41:32 GMT

Great Anil, This is what exactly I want.

Thanks a lot for your kind support.

Re: How to use between case in Conditional formatting

bhuprakash — Mon, 18 Dec 2017 07:13:32 GMT

Anil, Can you please teach me that how did you set the sorting priority of percentage.

Re: How to use between case in Conditional formatting

Anil_Babu_Samineni — Mon, 18 Dec 2017 07:19:46 GMT

Three approaches

1) May be play with Sort all possible options in side way to check the result

2) Paste all measures into Percentage By expression using bifurcate Addition(=) symbol

3) What i did, here is i am just promoting Percentage expression to the first place in sort tab using "Promote" button (This, I loved it )

Re: How to use between case in Conditional formatting

bhuprakash — Mon, 18 Dec 2017 07:41:58 GMT

Only AMM Name is coming in the Sort Tab.

Re: How to use between case in Conditional formatting

Anil_Babu_Samineni — Mon, 18 Dec 2017 12:05:28 GMT

I think, You are using Pivot table? In pivot table sort won't visible for measures. So, Think more ind detail each expression which are sorting correct way. So paste those expression by sort expression for dimension..