how to create an if statement measure in table

[Anonymous]

I currently have a report that I create in Excel using a Pivot Table. I use a very long if statement in order to calculate the productivity percentile using 4 columns in the pivot. (The if statement calculates outside of the pivot table.) Is there a way to add a measure in a Pivot Table in Qlik Sense that will allow me to use the if statement?

I have added an example of what I'm trying to recreate in Qlik (if you "drill down" in the pivot, the "measure" changes.)

[Anonymous]

Thank you!! It's correct for the County level now. How do I send you the qvf? I can easily disguise the data, just not sure how to send you anything other than excel attachments and screenshots. 😕 ! I see the !App icon in the bottom right, is that something I would select?

-Shannon

[luismadriz]

Hi Shannon, good to know it's working!

QVFs are the applications files. It depends if you're using Cloud, Desktop or Enterprise. If you're using Enterprise, you may need to ask the QMC admin.

What QS are you using?

Cheers,

Luis

[Anonymous]

I'm using Qlik Sense Cloud.

[luismadriz]

Hi, then on your "my work" stream, right click on the app and download and that's your qvf.

Cheers,

Luis

[Anonymous]

C:\Users\smann\AppData\Local\Temp\MOCK UP Productivity.qvf

Does that work? Because I can't figure it out. I've right clicked on the app and selected "download." From there I've tried saving it, but I don't have the right program to open it and then I've tried selecting "Open with Internet Explorer" and get this link, but can't actually do anything with it.

[luismadriz]

Yeap, that's the file you need to attach to this thread

Cheers,

Luis

[Anonymous]

https://us.qlikcloud.com/edit/5a14bd06f4cf8f0001e24bdd

Does that work? I'm heading out for the night. I REALLY, REALLY, REALY appreciate you! SO SORRY!!

[luismadriz]

I think I got a better idea, hover over my name or Bob's picture and click on Follow. After I approve it, you should be able to see my email address, then you can send me that qvf file via email.

Cheers,

Luis