Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Building Analysis Rules

Hi All,

I have a huge data sheet with columns such as VendorName, AcctDesp,JournalName,Amount etc and one blank column 'Category' on which I have to perform analysis . As a result of analysis this column should be populated with different categories.

To sort this data in categories I have rule sheet which has list of Vendor name With Category.

Like this I have other rulesheet with AccDesp and Category and few more.

I also have to define rules for amounts>some value and amount<somevalue.

Everything has priority and where the rules clashes the first rule should be given the priority.

Can any one suggest me the best way to do this please?

Thanks in advance.



Tags (2)