topic Re: 1 variable with 2 values in QlikView

1 variable with 2 values

LearnFreak — Fri, 26 Aug 2022 13:02:43 GMT

Hi,

I need to put 2 different values for 1 variable in the LoadScript of a report.

I am using the syntax with let -

LET Customer_name ='XXXX';

LET Customer_name ='YYYY';

But when I load data, I have data only for one customer but not the second one as well.

sidhiq91 — Fri, 26 Aug 2022 13:17:09 GMT

@LearnFreak Why under one same name? cant we use 2 different variables? And how are you planning to use them in the script?

LearnFreak — Fri, 26 Aug 2022 13:19:58 GMT

I want to load data only for those 2 customers....

sidhiq91 — Fri, 26 Aug 2022 13:52:57 GMT

@LearnFreak then in that case you can use inline load, something like below:

Table1:

Load * Inline [

Customer_name

XXXX

YYYY

];

LearnFreak — Fri, 26 Aug 2022 13:55:02 GMT

I tried another way and it worked...

I created 2 variables variable 1 and variable 2 and in the Load statement I used OR for both variables and it loaded data perfectly well 🙂