functions

[prat121]

Hello everyone, i am very new to qlik sense.

What my question is that what if I want to load the data of a particular location, like for example of bombay, how can we achieve this.

[PrashantSangle]

like SQL, you can use where clause in here

for e.g

Load * from table

where location = 'Bombay';

Regards,

Prashant Sangle

[prat121]

sorry prashant i misunderstood your answer, i tried this on the inline load i was unable to do it

[PrashantSangle · Accepted solution]

provide your sample data or script, will share you script.

you might try below code

Test:

Load * inline [

Location

bombay

goa

kolkata

];

Noconcatenate

Final:

Load * Resident Test

where location = 'bombay';

Drop table Test;

Regards,

Prashant Sangle

[prat121]

thanks a lot i was able to do it, as you said it actually concatenated. Also what if we dont know if its in capital or small letters what can be done

[prat121]

Also if i want to restrict the data in front end, like if there is sales vs category and i want this for only usa or india or any such location. i have tried it with the set analysis and if condition, is there any other way for it

[PrashantSangle · Accepted solution]

1: if we dont know if its in capital or small letters what can be done

> use wildmatch() for it like

 where wildmatch(location,'bombay');

2:  if i want to restrict the data in front end

> use set analysis like Sum({<location={'bombay'}>}Sales)

or

> create conditional dimension using if statement

Regards,

Prashant Sangle

[prat121]

Hello Prashant,

Thanku for the wildmatch, i was able to achieve it. Is there any other way apart from the set analysis and if conditions. Can we achieve this by using variable output if yes how

[PrashantSangle]

hmm. I don't think so.