topic Re: Conditionally load table with different parameters in where clause in QlikView

Conditionally load table with different parameters in where clause

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I would need to conditional load same table with different parameters depending on vPriceType variable's value

i.e.

Let vPriceType = Pick(Input('Would you please choose Price Type','Caption'),'Distri','Street');

IF '$(vPriceType)' = Distri

Load:

AllPrices: 
LOAD ID,  
     Country,  
     Source,  
     Price,  
     Date(Date) AS Date 
FROM 
AllPrices.csv 
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
Where Country = 'UK';

Elseif '$(vPriceType)' = Street

Load:

AllPrices: 
LOAD ID,  
     Country,  
     Source,  
     Price,  
     Date(Date) AS Date 
FROM 
AllPrices.csv 
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
Where Country = 'DE';

Else Let vPriceType = Pick(Input('Would you please choose Price Type','Caption'),'Distri','Street');

Thanks in advance for your help.

Amko

Re: Conditionally load table with different parameters in where clause

Gysbert_Wassenaar — Mon, 06 Mar 2017 18:10:03 GMT

Perhaps like this:

Switch '$(vPriceType)'

Case 'Distri'

SET vCountry = 'UK';

Case 'Street'

SET vCountry = 'DE';

Case '...something else...'

SET vCountry = '...whatever...';

Default

SET vCountry = '...a default fallback value...';

End Switch

AllPrices:

LOAD ID,

Country,

Source,

Price,

Date(Date) AS Date

FROM

AllPrices.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where Country = '$(vCountry)';

Re: Conditionally load table with different parameters in where clause

maxgro — Mon, 06 Mar 2017 18:41:13 GMT

LOAD ID,

Country,

Source,

Price,

Date(Date) AS Date

FROM

AllPrices.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

where

Country = pick(wildmatch('$(vPriceType)', 'Distri','Street'), 'UK', 'DE')

;

Re: Conditionally load table with different parameters in where clause

Tue, 07 Mar 2017 11:15:39 GMT

Thank you Gysbert

Re: Conditionally load table with different parameters in where clause

Tue, 07 Mar 2017 11:16:17 GMT

Grazie Massimo