topic Re: If condition Problem in QlikView

If condition Problem

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

Hi all,

I was struck with an senario of if condition .Please help me out.

i have a table like ID,ledger code,Subledger1,Subledger2

Here ID and Ledger code is unique.But Subledger1 and 2 in not.wat my requirement is

ID,ledger code,Subledger1,Subledger2

101,4041,LG/mg/00001,0

101,4041,40432,0

I want to show only the LG/mg/00001 row the below one should be hide..

These are dimensions .Subledger1,Subledger2 only.Only for 2 id;s i have to hide in my table remainig all are unique.

Anil_Babu_Samineni — Mon, 15 Jan 2018 07:25:28 GMT

May be use expression like FirstSortedValue(Subledger1, ID)

dathathreya — Mon, 15 Jan 2018 07:44:09 GMT

Firssorted value will work on expression i think while i am using this it is showing error.

pradosh_thakur — Mon, 15 Jan 2018 08:29:31 GMT

why not use

where Subledger1='LG/mg/00001'

Anil_Babu_Samineni — Mon, 15 Jan 2018 08:45:49 GMT

What error you are facing using that? Does all fields from same table?

vinieme12 — Mon, 15 Jan 2018 09:57:36 GMT

if you only want to show Text values in Subledger1 then use IsText()

=if(isText(Subledger1),Subledger1) and check supress null values on this dimension