topic Re: HardCode Value in QlikView

HardCode Value

priyarane — Tue, 18 Jul 2017 07:03:21 GMT

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

Re: HardCode Value

zhadrakas — Tue, 18 Jul 2017 07:16:10 GMT

try like this:

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

Concatenate
Load
'C' as Dim,
sum(Val) as Val,
sum(Val1) as Val1
Resident tmp;

regards

tim

Re: HardCode Value

priyarane — Tue, 18 Jul 2017 07:30:20 GMT

It will work but my actual datamodel is huge so I cannot touch it so I need it as expreesion.

thanks for the reply.

Re: HardCode Value

prma7799 — Tue, 18 Jul 2017 07:35:01 GMT

Have you tried this

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

Re: HardCode Value

zhadrakas — Tue, 18 Jul 2017 07:39:03 GMT

if(Dim='C', sum(TOTAL if(match(Dim, 'A', 'B'), Val1)))

if(Dim='C', sum(TOTAL if(Dim <> 'C', Val1)))

Re: HardCode Value

priyarane — Tue, 18 Jul 2017 07:44:05 GMT

tried but no luck

Re: HardCode Value

priyarane — Tue, 18 Jul 2017 07:44:13 GMT

tried but no luck

Re: HardCode Value

bhargav_bhat — Tue, 18 Jul 2017 07:50:41 GMT

Hi,

Please let me know if this works

if(Dim='C',sum({$<Dim=>} Val1),sum(Val1))

Re: HardCode Value

zhadrakas — Tue, 18 Jul 2017 07:58:11 GMT

didn't realize that you want to select 'C'.

Then you use Set Analysis the remove the selection

if(Dim='C', Sum({<Dim=>}Val1), sum(Val1))

Re: HardCode Value

priyarane — Tue, 18 Jul 2017 08:21:19 GMT

it is already tried and it is not working

Re: HardCode Value

priyarane — Tue, 18 Jul 2017 08:21:28 GMT

it is already tried and it is not working

Re: HardCode Value

zhadrakas — Tue, 18 Jul 2017 08:23:11 GMT

that should work. can you share a sample qvw?

Re: HardCode Value

balar025 — Tue, 18 Jul 2017 08:27:29 GMT

PLease find application with same set of data.

Re: HardCode Value

priyarane — Tue, 18 Jul 2017 08:50:30 GMT

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

Re: HardCode Value

passionate — Tue, 18 Jul 2017 08:50:36 GMT

Hi Priya,

Please find attached solution.

Regards,

Pankaj

Re: HardCode Value

balar025 — Tue, 18 Jul 2017 09:19:45 GMT

Please find new app for solution.