HardCode Value

[priyarane]

Hi Community,

I have table like below. And requirement is if Dim=C then I need sum(Val1) and I have writtern expression like below but problem is if I select any Dim value then it is disappearing but as per my requirement it shouldn't be disappear. so If I select A then C value is 100 and for B 200 and for C 300.

LOAD * INLINE [
Dim, Val, Val1
A, 10, 100
B, 20, 200
C
];

if(Dim = 'C',
$(=sum(Val1)),
sum(Val)
)

-Priya

[priyarane]

it is already tried and it is not working

[zhadrakas]

that should work. can you share a sample qvw?

[balar025]

PLease find application with same set of data.

[priyarane]

Hi Thanks for the effort, if I select A then C is disappearing, it should not happen

[passionate]

Hi Priya,

Please find attached solution.

Regards,

Pankaj

[balar025 · Accepted solution]

Please find new app for solution.