topic Re: How to read & use short formulas in QlikView

How to read & use short formulas

girish_talele — Fri, 14 Nov 2014 05:38:57 GMT

Dear Expert,

How to read & use such short formulas (we are using traditional IF, ELSE formulas)

COUNT({($<WHATEVER={WHATEVER}>)} WHATEVER)

is there any documentation on the same.

Regards,

Girish

jagan — Fri, 14 Nov 2014 05:47:51 GMT

Hi,

Can you explain bit more what you are trying to do with an example.

Example:

Sum({<Country={'India', 'USA'}>} Sales)

Regards,

jagan.

tresB — Fri, 14 Nov 2014 05:48:57 GMT

Search "set analysis" in qv help. PFA as well.

sushil353 — Fri, 14 Nov 2014 05:53:27 GMT

Hi,

the below wizard will help you out to write set analysis

tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

add http:/ before the above URL.

HTH

sushil

jagan — Fri, 14 Nov 2014 06:03:00 GMT

Hi,

Refer Qlikview Help file (F1) for detailed explanation of Set analysis concepts. Open help file F1 and check for Set Analysis topic.

Hope this helps you.

Regards,

jagan.

girish_talele — Tue, 18 Nov 2014 13:23:58 GMT

Thanks Everybody.....