QlikSense tutorial: STOP using IF!!! Use these functions instead !! Peak & match funktions qliksense

[@thinkmetrics]

🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass 📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet

[@praveenteja2474]

Hi ,i am very much eager to buy your course and very interested to learn,but could you please provide me a coupon code ,i cannot afford that much fee as I'm a student

[@thinkmetrics]

Send me an email [e-mail]

[@KeyBorg1]

I use this myself, but there are multiple masters that explain that this is not in any way faster than IF. It may seem simpler (and I believe it is), but it is not computationally faster at all.

[@thinkmetrics]

👍🏻

[@RohitSingh-we9mo]

Hi Thinkmetrics I have a query regarding pick match. Let say I have multiple value of geography and there are some null values as well. I want the null values to be tagged as 'NA' and rest all the geography value would be same as the value available in geography. It might be the case that some geography value may add in the near future so we need to write the code like we do not need to make enhancement in the code

[@davidserey9129]

Cuales son los resultados al usar if vs peak?

[@neerusaini1303]

Can we do pick and match for more than 2 conditions?

[@williamandersson7158]

Great stuff!

[@thinkmetrics]

Thanks, mate 🙏

[@naveenkumardks678]

very informative

[@thinkmetrics]

👍👍👍👍👍

[@e-k9174]

Hello, I have an issue using the method you have mentioned.. I have an Excel file with 7 sheets... I am using this formula instead of "IF ELSE statement"; when I tried to access the data of the first sheet in Excel, everything went fine, and the data returned was right, but when I tried to access the second sheet, in the same formula, the returned data wasn't right. I ve tried to debug this issue, to find the problem where I have to use it only in one sheet and write another formula for the second sheet, but I need to use the same formula to get 1 column and the data that are in that column should be returned from different sheets.. any solution? or anyone know how to do that?

[@PrakharLadhwe]

Will pick and match work for every "if expression" like even if there is a Boolean expression ?

[@PS-vc6ef]

Can you please do one with set analysis. e.g If(SUM({}Sales1) >= 10000, black(), blue())

[@PrakharLadhwe]

Answer this ?

[@neerusaini1303]

Hi, have you got your answer?

[@Surajsp0104]

Please share real time tips for qlik dashboard optimization

[@thinkmetrics]

👍🏻

[@pumapumi7293]

Good

[@thinkmetrics]

🙏🙏🙏

[@msatheesh4495]

🎉

[@thinkmetrics]

👍🏻