Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Bharathi09
Creator II
Creator II

Qlik to PBI migration

Hello All,

I Have below qlik logic which I need to show in Power BI custom Column

if(len([Alternate  Flag])=0 and len([Alternate SD Flag])=0,'N',
if(len([Alternate  Flag])=0 and [Alternate  SD Flag]='Y','Y-USA',
[Alternate  Flag]) as Flag_Check

I have only record 'Y' in both Alternate Flag and Alternate SD Flag that is 'Y'

but in output it's showing all three value N, Y, Y-USA in Qlik

How it could be possible?

and please help me in converting this to PBI

Thanks!

1 Solution

Accepted Solutions
TauseefKhan
Creator III
Creator III

Hi @Bharathi09,

Check with this:

Flag_Check =
IF(
LEN([Alternate Flag]) = 0 && LEN([Alternate SD Flag]) = 0,
"N",
IF(
LEN([Alternate Flag]) = 0 && [Alternate SD Flag] = "Y",
"Y-USA",
[Alternate Flag]
)
)

******** Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.********

View solution in original post

1 Reply
TauseefKhan
Creator III
Creator III

Hi @Bharathi09,

Check with this:

Flag_Check =
IF(
LEN([Alternate Flag]) = 0 && LEN([Alternate SD Flag]) = 0,
"N",
IF(
LEN([Alternate Flag]) = 0 && [Alternate SD Flag] = "Y",
"Y-USA",
[Alternate Flag]
)
)

******** Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.********