Restrict colomn of a row

[#1]

Hi Guys,

I want to show 0 in Product B under Stage 2. How can I restrict it in dimension or in expression please.

Time in Hours
Product	Stage 1	Stage 2	Stage 3	Total
A	5	2	4	11
B	1	2	3	6
C	7	8	6	21

[richard_chilvers]

Hi Shoaib

How do you decide when you'd like a 0 to show ? Is there a rule?

[#3]

Hi Richard,

By default Product B under Stage should be 0. But the the application can have more than one products. e.g. application has product A and B. In this case my code shows the same time in A and B i.e. 2. But actually under B and Stage 2 it should be 0.

[#4]

Hi Shoaib,

Try the below condition in script (if Product and Stage2 are in a same table).

if(Product='B',0,Stage2) as Stage2

If the above doesn't help please share the sample app to understand it better.

--

Vinoth

[#5]

Hi Vinoth.

I need to solve the following thread please:

http://community.qlik.com/thread/109500

[#6]

Sure shoaib.

At the same time if you got the answer for the above thread please mark the correct answer and close the thread.

--

Vinoth