topic Set analysis equal fields in QlikView

Set analysis equal fields

eleni_theodorid — Thu, 13 Sep 2012 12:18:40 GMT

How do I have to syntax this Set Analysis sum({$<FieldA={FieldB}>} TOTAL Sales). See attached a document were this problem occures. At the column test i want to have 6000, 2000 and 7000. Any help will be apriciated!

Re: Set analysis equal fields

Thu, 13 Sep 2012 12:59:18 GMT

Ελενη

The numbers you are expecting are valid when the data are grouped by BudgetYearMonth.

So if you develop an expression like this: sum(TOTAL <BudgetYearMonth> Budget) and use as a dimension the BudgetYearMonth it will work. Otherwise, the data model does not makes sense at least to me.

Hope it helps...

Re: Set analysis equal fields

Anonymous — Thu, 13 Sep 2012 14:08:45 GMT

Hi,

Maybe try month as one field, regardless of whether budget or transaction.

You can do that by putting both sets of data in the same table, with CardID and Month being common to both types of data. Else you can create a link table that include CardId and Month and then links off to transactions or Budget tables.

With month linked you can then set that as your dimension (see attached)

In case you knew all this and were using this example to simplify a more complex situation, I couldn't get the set analysis working the way the Advanced design and development manual suggests you should. Apparantly you can type something like "Sum({$<OneDate=AnotherDate>} Amount)", though I am a little suspicious as their example missed out the closing curly brace '}' symbol.

Regards,

Jonathan

Re: Set analysis equal fields

eleni_theodorid — Fri, 14 Sep 2012 06:24:15 GMT

Dear All,

Thank you for your reply. The data model is exact what we want and unfortunatelly we want to have only that fields as dimensions in the chart.

Jonathan, as you can see in my attached that's (something like "Sum({$<OneDate=AnotherDate>} Amount)") exactly what i want to do but the problem is that it's only works when the user make selection on the YearMonth field, that's why i need help!

Regards,

Eleni