topic Re: How to write in dimension for the below query ? in QlikView

How to write in dimension for the below query ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

How to write in dimension .

select distinct dealgroup_id from deal where dealstate_id in (34)

Re: How to write in dimension for the below query ?

jyothish8807 — Tue, 18 Sep 2018 12:30:28 GMT

Hi ,

Try this;

if(dealstate_id='34',dealgroup_id)

Br,

Re: How to write in dimension for the below query ?

suvechha_b — Tue, 18 Sep 2018 12:43:00 GMT

Hi ,

Actually , my requirement is -

I got

dealgroup_id,dealstate_id

4642862 3

4642862 38

4642862 34

4642862 33

So , if dealstate is 33 then don't show dealgroup_id but if all of them is 34 then show.

Re: How to write in dimension for the below query ?

vishsaggi — Tue, 18 Sep 2018 13:59:35 GMT

So what is the issue with Jyothish If expr? Did you try that? You want to show ID whose dealstate is 34 right? Based on your data only 34 dealstate and dealgroup will be visible.