If problem

[#1]

Hi,

2 weeks old into QV, and trying to get on board with the basics.

I have data in columns, SalesID, LA, LP, VO. There are basically 2 values on columns LA,LP, VO, either 1 or 0. I would like to create a 5th column that checks that if there is 0 on any of the columns in the row, then the new row value is 1, otherwise it is 0.

if((LAr or VO or LP) = 0, 0, 1) as VR. This however doesn't work.

After this would like to create 4 new tables.

SalesID, LA =1

SalesID, VO =

SalesID, LP =1

SalesID, VR =1

Help on this much appreciated...

[its_anandrjs]

If got correct so mark my thread as correct so refer it as correct

Thanks & Regards

[its_anandrjs]

Change expression like

If ( LA = 0 OR VO = 0 OR LP = 0, 0, 1) as VR

Thanks & Regards

[#4]

For creating 4 tables, take straight table from charts,

in that take 2 dimensions: 1) sales ID and 2) calculated dimension- =if(LA=1,LA,null())

and for this expression check box "suppress null values"

and in expression write down "1" and in Presentation tab select 1 and click on hide expression column

U will get the result and do the same for the rest.