topic Re: Case condition in QlikView

Case condition

soniasweety — Sat, 16 Nov 2024 01:01:46 GMT

Hi all,

I have data like attached excel. if any side of the column have null values i want to get the data.

YYear ,

EYear, these two fields i need to get as one field as Year

if(YYear=Null,EYear,YYear ) as NewYear i want to get all the data . into single filed

either YYear is null or EYear null i want to show the data.

Re: Case condition

Taoufiq_Zarra — Wed, 18 Mar 2020 13:41:05 GMT

one approche

LOAD left(Yyear&EYEar,6) as NewYear, left(Ymonth&Emonth,6) as NewMonth, Ysales, Esales, [Diff Net Sales] FROM .\condition.xlsx (ooxml, embedded labels, table is Sheet1);

Re: Case condition

soniasweety — Wed, 18 Mar 2020 13:43:58 GMT

thanks for the input but.. i have total 34 columns

so i want to make 17 columns i want if condition only 😞

Re: Case condition

Taoufiq_Zarra — Wed, 18 Mar 2020 13:49:06 GMT

LOAD if(len(trim(Ymonth))=0,Emonth,Ymonth) as NewMonth, if(len(trim(Yyear))=0,EYEar,Yyear) as NewYear, ...

I don't know if I fully understand your requirement...

Re: Case condition

soniasweety — Wed, 18 Mar 2020 13:53:40 GMT

Yeah i dont want to trim nulls

i want to show null values in the data .

my data looks like

Yregion , Eregion

America, Null

America, America

Null,America

America,Null

i want to get all the data with that if condition as one filed.

Re: Case condition

Taoufiq_Zarra — Wed, 18 Mar 2020 13:56:16 GMT

So from :

Yregion , Eregion

America, Null

America, America

Null,America

America,Null

what is the expected output ?

Re: Case condition

soniasweety — Wed, 18 Mar 2020 13:58:41 GMT

from this field i want to create one field .

i have two measures - Esale and Ysales

if i select Month, or year from the listbox it should take the respective field . along with nulls

Re: Case condition

Taoufiq_Zarra — Wed, 18 Mar 2020 14:04:26 GMT

I'm sorry @soniasweety , but I didn't always understand the request !

Re: Case condition

soniasweety — Wed, 18 Mar 2020 14:12:08 GMT

The issue im facing is

two different column names and values are same.

but i want to make as single field instead of keeping two seperate field s in the dashboard.

Ysales, Esales and Differance Ysales-Esales this should match when i use the final field which we are creating as in if condition

Re: Case condition

Taoufiq_Zarra — Wed, 18 Mar 2020 14:19:23 GMT

can you give me the expected result?
display in an excel or on paint, just to illustrate your idea.