topic Re: Load data for multiple conditions simultaneously in QlikView

Load data for multiple conditions simultaneously

sujit_nath — Sat, 16 Nov 2024 04:19:31 GMT

My requirement is as such:

I have a csv from which I am loading the data.

-Suppose I have 3 conditions

1. field A = 'Y'

2.feild B='N'

3.feild C<>'Y'

-So, my load statement would be like --

load * from myfile

where

field A = 'Y'

AND

feild B='N'

AND

feild C<>'Y'

;

-Now I want to check how many records are eliminated only due to feild c<>'Y' , but my actual load should contain that elimination.

How do I achieve that?

Re: Load data for multiple conditions simultaneously

VishalWaghole — Wed, 27 Feb 2019 12:05:47 GMT

Hi Sujit,

In first load you can load all rows without using where clause. Once load then assign noofrows to one variable using NoOfRows function. Then take resident load from above table there you can use where condition as Field C not equal to Y. Again store noofrows from newly loaded table to one more variable. Then you can substract new variable from previous one and assign that value to final variable. Final variable will store your number that you want. After this again load data from first loaded table there you can use field A and field B condition in where clause and concatenate that with table where you have used field C condition.

Hope you understand.

Thanks,
Vishal Waghole

Re: Load data for multiple conditions simultaneously

anushree1 — Wed, 27 Feb 2019 12:55:08 GMT

Please check the NoOfRows() in this link:https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/TableFunctions/NoOfRows.htm

Re: Load data for multiple conditions simultaneously

sunny_talwar — Thu, 28 Feb 2019 12:04:57 GMT

May be do another load like this

ExclusionCount:
LOAD Count(feild C) as CountFieldC
FROM myfile
Where feild C <> 'Y';

Concatenate(ExclusionCount)
LOAD Count(feild B) as CountFieldB
FROM myfile
Where feild B='N';

Concatenate(ExclusionCount)
LOAD Count(feild A) as CountFieldA
FROM myfile
Where field A = 'Y';