https://community.qlik.com/t5/QlikView/How-to-get-two-different-values-on-the-single-column/m-p/1867353#M1216382 <P>Hi,</P> <P>Is anybody able to provide an answer for me? I would like to adjust the scale min for one particular column, which is Segment.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tonytang_1-1638843338270.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/68032i153C11D2736FDD0D/image-size/medium?v=v2&amp;px=400" role="button" title="tonytang_1-1638843338270.png" alt="tonytang_1-1638843338270.png" /></span></P> <P>&nbsp;</P> <P>The Segment have 4 values, Business_1, Business_2,Business_3,Business_4. I wanna set up 100, 150,200, 300 for the respective segments. However, I also want to set up 150 for Business_1 and Business_2, then run into an issue here. Even i used "And" or "WildMatch", but eventually it fail to achieve my purpose.&nbsp;</P> <P>What i want to do is very simple, just like [If(Segment=Business_1 and Segment=Business_2, 150].&nbsp;</P> <P>Is there anyone providing your assistance to me? It is a bit urgent task to do in my end. It is my pleasure if i got your valuable answer here .</P> <P>Thanks in advance</P> <P>&nbsp;</P> Tue, 07 Dec 2021 02:18:54 GMT tonytang 2021-12-07T02:18:54Z https://community.qlik.com/t5/QlikView/How-to-get-two-different-values-on-the-single-column/m-p/1867353#M1216382 <P>Hi,</P> <P>Is anybody able to provide an answer for me? I would like to adjust the scale min for one particular column, which is Segment.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tonytang_1-1638843338270.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/68032i153C11D2736FDD0D/image-size/medium?v=v2&amp;px=400" role="button" title="tonytang_1-1638843338270.png" alt="tonytang_1-1638843338270.png" /></span></P> <P>&nbsp;</P> <P>The Segment have 4 values, Business_1, Business_2,Business_3,Business_4. I wanna set up 100, 150,200, 300 for the respective segments. However, I also want to set up 150 for Business_1 and Business_2, then run into an issue here. Even i used "And" or "WildMatch", but eventually it fail to achieve my purpose.&nbsp;</P> <P>What i want to do is very simple, just like [If(Segment=Business_1 and Segment=Business_2, 150].&nbsp;</P> <P>Is there anyone providing your assistance to me? It is a bit urgent task to do in my end. It is my pleasure if i got your valuable answer here .</P> <P>Thanks in advance</P> <P>&nbsp;</P> Tue, 07 Dec 2021 02:18:54 GMT https://community.qlik.com/t5/QlikView/How-to-get-two-different-values-on-the-single-column/m-p/1867353#M1216382 tonytang 2021-12-07T02:18:54Z