Show more than one measure using filters

[#1]

I have added four dimensions in line chart, I need to show that four lines depending upon the filter selection. When I select single value in filter it shows a single line but when I select multiple values in filter, it shows me blank.

[sunny_talwar]

4 dimensions? Why would you need 4 dimensions to display 4 lines. Is your data in pivot table format? Can you share some image and show us what you are trying to do?

[#3]

4 Measure, each measure is made up of expressions. Need to show measures based upon filter selection. single selection in filter shows single measure, two selection in filter should show two measures that is two lines in line chart.

[sunny_talwar]

so its 4 expressions and not 4 dimensions? or is it some combination? Before I can give any suggestion, it would be helpful to know what you have. Sharing your application or at least sharing screenshot can help. Is it possible to share?

[#5]

First expression - IF(PRODUCT='A', SUM(XYZ), 0)

First expression - IF(PRODUCT='B', SUM(DEF), 0)

First expression - IF(PRODUCT='C', SUM(ABC), 0)

First expression - IF(PRODUCT='D', SUM(MNP), 0)

These are four measures, I need to show comparison in line chart based upon filter selection of products. Will this help?

[Anonymous]

What condition have you write on expression? It seems that conditional expression is wrong

[sunny_talwar]

You really need to read this QlikCommunity Tip: How to get answers to your post?‌

If you want somebody to really help you, you need to provide enough details. I have not idea what are you selecting, I don't know what dimensions you have, you are completely ignoring my request to share screenshots or dummy application (at least mention that the data is confidential and cannot be shared).

I think I will let someone else help you and if in case you plan to elaborate a little, I will be more than happy to come back to help you out

Just so you if your data is confidential, there is a way to scramble it

Preparing examples for Upload - Reduction and Data Scrambling

[#8]

I have four products in one column, I have made four measure to calculate sales of these four products.

Used line chart to display monthly sales of these four products. I want that if I selected Product 1 in filter then only sales of product1 should be shown in line chart, when I selected product2 in filter then sales of product2 should be shown in line chart and when I select both product1 and product2 in filter then sales for both the products should be shown in line chart.

would not be able to upload dummy data or screenshot for it.

[sunny_talwar · Accepted solution]

You are summing different fields for each of the product? I guess you know what you are doing, try this:

SUM({<PRODUCT *= {'A'}>}XYZ)

SUM({<PRODUCT *= {'B'}>}DEF)

SUM({<PRODUCT *= {'C'}>}ABC)

SUM({<PRODUCT *= {'D'}>}MNP)

UPDATE: For each of the 4 expression, add an expression in conditional section above where you are adding your regular expression to display the chart

For Product A -> SubStringCount(Concat(DISTINCT PRODUCT, '|'), 'A') = 1

For Product B -> SubStringCount(Concat(DISTINCT PRODUCT, '|'), 'B') = 1

For Product C -> SubStringCount(Concat(DISTINCT PRODUCT, '|'), 'C') = 1

For Product D -> SubStringCount(Concat(DISTINCT PRODUCT, '|'), 'D') = 1

[jonathandienst]

Why not create a single expression without product filters, and let the user select the the product(s) in a list box?