topic Re: Set Analysis in Chart Dimension in QlikView

Set Analysis in Chart Dimension

infosense_devel — Tue, 31 May 2016 17:05:43 GMT

Can we use Set Analysis in Chart's Dimension?

e.g. =({<REC_TYPE={'BudgetRec', 'InvoiceDateRec'}>} BILL_TO_CUST_ACCOUNT_NUMBER)

Re: Set Analysis in Chart Dimension

sunny_talwar — Tue, 31 May 2016 18:22:14 GMT

Try this:

If(Match(REC_TYPE, 'BudgetRec', 'InvoiceDateRec'), BILL_TO_CUST_ACCOUNT_NUMBER)

Re: Set Analysis in Chart Dimension

sunny_talwar — Tue, 31 May 2016 18:23:28 GMT

Or this:

Aggr(Only({1<REC_TYPE = {'BudgetRec', 'InvoiceDateRec'}>} BILL_TO_CUST_ACCOUNT_NUMBER), BILL_TO_CUST_ACCOUNT_NUMBER)

Re: Set Analysis in Chart Dimension

Wed, 01 Jun 2016 10:40:56 GMT

Hi,

I would create a flag field in the back-end script and use set-analysis in the expression in the object in question.

Regards,

Pravesh

Re: Set Analysis in Chart Dimension

tvsr111 — Sun, 03 May 2020 16:44:59 GMT

Hi Sunny, Hope you are doing good

I need a help with Set Analysis on character (Dimension nature) Attributes

* Set Analysis does work on Measures when using SUM() & COUNT() functions

Measures:

Amount=sum({<[StartDate]={"<=$(varInputDate)"}, [EndDate]={">=$(varInputDate)"}>} OrderAmount)

QtyCount=count(distinct {<[StartDate]={"<=$(varInputDate)"}, [EndDate]={">=$(varInputDate)"}>} OrderAmount)

* But Set Analysis on Character (Dimension) attributes not working

Dimensions:
CustomerName= aggr(only({<[StartDate]={"<=$(varInputDate)"}, [EndDate]={">=$(varInputDate)"}>} CustName), CustName)
StoreLocation= aggr(only({<[StartDate]={"<=$(varInputDate)"}, [EndDate]={">=$(varInputDate)"}>} StoreLoc), StoreLoc)
OrderDate= aggr(only({<[StartDate]={"<=$(varInputDate)"}, [EndDate]={">=$(varInputDate)"}>} OrderDate), OrderDate)

We have a specific scenario where we need to apply this set analysis on Dimension columns also along with Measures.
we will use these on charts and table visualizations tooo

the expressions shown are only sample to explain the issue