Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Multiple Dimensions

Hi,

I would like to add a table where I have 2 summary fields as expression (total value for example). In the dimension I want the top line to be Total and the second line to be the total where a certain criteria is met. What is the best way to achieve this?

For example

        

               sum value

Total           2500

with criteria 1800

many thanks

5 Replies
er_mohit
Honored Contributor II

Re: Multiple Dimensions

can you attached your sample file...

i didnot get you exactly

Not applicable

Re: Multiple Dimensions

Hi, many thanks for your help. The raw data looks like:

number       criteria1  criteria2

acnumber1     1          0

acnumber2     0          0

acnumber3     0          1

acnumber4     1          1 

what i would like to show is the number of accounts that meeti criteria1 and the number that meet criteria2 and the total in a straight table.

My dimensions would be the criterias and only count the account number where this is met. I have set up a flag for this criteria so it shows as 1 or 0, I would like to summarise this data as below:

              number of accounts

criteria1

criteria2

please let me know if this does not make sense.

Not applicable

Re: Multiple Dimensions

Hi, many thanks for your help. The raw data looks like:

number       criteria1  criteria2

acnumber1     1          0

acnumber2     0          0

acnumber3     0          1

acnumber4     1          1 

what i would like to show is the number of accounts that meeti criteria1 and the number that meet criteria2 and the total in a straight table.

My dimensions would be the criterias and only count the account number where this is met. I have set up a flag for this criteria so it shows as 1 or 0, I would like to summarise this data as below:

              number of accounts

criteria1

criteria2

please let me know if this does not make sense.

Not applicable

Re: Multiple Dimensions

Would you accept, as result, the data (criteria1, criteria2, total) in diffent columns instead of rows?

Regards,

Daniele

Not applicable

Re: Multiple Dimensions

Hi,

I attached a solutions.

Regards!