Qlik Sense Cheat Sheet version 2.0

[ArturoMuñoz]

It was back in 2015 when I first published the original Qlik Sense Search Cheat Sheet. Since then, and thanks to lots of individual contributors here in the Community, the Search Cheat Sheet has suffered several transformations to make it more complete and truthful.

@afurtado wrote me an email a few weeks ago because he was interested in getting the document localized for the Brazilian folks out there. In addition to thank him for his contribution and sending him the file I decided that it was about the time to get the Search Cheat Sheet an update. 

Today I want to introduce a new version of the document. I added the compound search section to it (@jayanttibhe  thanks for the tip), and I redesigned and rationalized the position of each element for better comprehension.

As an extra, I made the document multilanguage ready. So, if someone wants to translate the Cheat Sheet to other language (currently available in English, Spanish and Portuguese) please let me know in the comments section and I'll gladly tell you how to help us.

Language	URL	Contributor(s)
English - USA	https://webapps.qlik.com/search-cheat-sheet/Qlik+Sense+Search+Cheat+Sheet+en-US.pdf
Portuguese - Brazil	https://webapps.qlik.com/search-cheat-sheet/Qlik+Sense+Search+Cheat+Sheet+pt-BR.pdf	@afurtado
Spanish - Spain	https://webapps.qlik.com/search-cheat-sheet/Qlik+Sense+Search+Cheat+Sheet+es-ES.pdf
German	https://webapps.qlik.com/search-cheat-sheet/Qlik+Sense+Search+Cheat+Sheet+de-DE.pdf	@g_mitschke
Russian	https://webapps.qlik.com/search-cheat-sheet/Qlik+Sense+Search+Cheat+Sheet+ru-RU.pdf	@martynova
Italian	https://webapps.qlik.com/search-cheat-sheet/Qlik+Sense+Search+Cheat+Sheet+it-IT.pdf	@AntonioCostantino
French	http://webapps.qlik.com/search-cheat-sheet/Qlik+Sense+Search+Cheat+Sheet+fr-FR.pdf	@arychener

Hope you like it, and please share it.

Arturo

Updates:

Feb 28: French version thanks to @arychener 

Feb 25: Italian added thanks to @AntonioCostantino . Russian translation updated

Feb 13, 2020: Cheat sheet includes now the ^ Wildcard to be consistent with Qlik Help. Russian language added thanks to the contribution of @martynova 

Jan 29, 2020: German language added thanks to the contribution of @g_mitschke 

[Stanislav_P]

Hello, Russian translation link is not working. 

[ArturoMuñoz]

Thanks @Stanislav_P, link fixed

[Lauri]

This is very nice, thanks for providing! Is there a way to search for numeric values in a field that contains the greater than symbol (>) as a text value? When I type >5, I get no results because Qlik interprets it as text. (Also, your image is fairly small and not so easy to read...)

[ArturoMuñoz]

Hi Lauri, you can find the link to the actual cheat sheet at the bottom of the post. 

While searching on a numeric field that has been loaded as a text you could do:

Where text is the field you are trying to convert to a number and '#.##0' is the desired format, in this case an integer.

If you field contains a '>5' string then you can use a compound search, to search 2, 4 and >5 for example

Cheers

[Hevel]

Thank you, very useful.

[LDR]

Hi @ArturoMuñoz 

Should it be possible to run something like that?

=Num#(Text,'#.##0')>12Num#(Text,'#.##0')<100

I tried and it doesn't work. So, is it possible to concatenate several functions? At the end my search would the same than:

>12<100

In my case I found a workaraound using a filter pane object and converting the text field to number, but I would like to know how flexible is Qlik.

Thanks in advance