topic Re: sorting data in a straight chart in QlikView

sorting data in a straight chart

0li5a3a — Tue, 16 May 2017 10:22:52 GMT

Hi all,

I need your help. I have a straight chart with 3 columns and need to filter the data. EX

column 1 column 2 column 3

123456 abcd INDOOR

235466 bbcs OUTDOR

23564 abcd

I want to restrict the data just to be able to see the columns which contain the values INDOOR.

I want to restrict the data only in this specific chart not in the all appreciation.

Could you please suggest what I need to do?

Thank you in advance!

Re: sorting data in a straight chart

qlikview979 — Tue, 16 May 2017 10:30:31 GMT

Not sure

are you expecting to show straight table only 'INDOOR' right .

Re: sorting data in a straight chart

0li5a3a — Tue, 16 May 2017 10:30:54 GMT

yes please

Re: sorting data in a straight chart

0li5a3a — Tue, 16 May 2017 10:33:00 GMT

I tried to use IF and ONLY but I can't restrict the data....

Re: sorting data in a straight chart

qlikview979 — Tue, 16 May 2017 10:33:03 GMT

try this

Re: sorting data in a straight chart

tresB — Tue, 16 May 2017 10:34:10 GMT

If there is any aggregation function (min, max, sum, count....) you are using in the chart, you can use set analysis to restrict the output like:

Sum({<FieldName={'INDOOR'}>} Sales)

Now, change it to your context.

Re: sorting data in a straight chart

qlikview979 — Tue, 16 May 2017 10:36:02 GMT

you try like this also

with only() function

only({<[column 3]={'INDOOR'}>}[column 3])

Re: sorting data in a straight chart

sanjay006 — Tue, 16 May 2017 10:36:39 GMT

Re: sorting data in a straight chart

sanjay006 — Tue, 16 May 2017 10:40:29 GMT

=if(WildMatch(column 3,'INDOOR'),column 3)

if u want in your dimension.

and if u want it in value

Sum({<column 3,={'INDOOR'}>} value)

Re: sorting data in a straight chart

0li5a3a — Tue, 16 May 2017 11:06:58 GMT

I tried your code but I have a problem with the nulls. How I can exclude nulls?

Re: sorting data in a straight chart

sanjay006 — Tue, 16 May 2017 11:10:54 GMT

just suppress the null values

Re: sorting data in a straight chart

0li5a3a — Tue, 16 May 2017 11:11:54 GMT

I tried to add your code but Enable conditional doesn't works in this case...

Thanks

Re: sorting data in a straight chart

sanjay006 — Tue, 16 May 2017 11:12:15 GMT

In dimension tab select the dimension in which u don't want to see the null value and suppress.

Re: sorting data in a straight chart

qlikview979 — Tue, 16 May 2017 11:12:27 GMT

Select Dimension

Click on "suppress when value is null " in Dimensions Tab.

Re: sorting data in a straight chart

0li5a3a — Tue, 16 May 2017 11:34:05 GMT

Hi all,

I tried all of your advise and I found the following:

add this =only({<[Column 3]={'INDOOR'}>}[Column 3])

- like dimension nothing is changed

- like expression you would see that not only the INDOOR columns, the nulls are too , if you try to suppress zero values or suppress missing noting is changed

Thanks your your help

Re: sorting data in a straight chart

qlikview979 — Tue, 16 May 2017 11:35:41 GMT

please share the app

Re: sorting data in a straight chart

sanjay006 — Tue, 16 May 2017 11:36:11 GMT

Don't use this in enable condition use this as a dimension.

Add calculated dimension and use this .

Re: sorting data in a straight chart

Anil_Babu_Samineni — Tue, 16 May 2017 11:39:41 GMT

Is this you are expecting? If not, You must share exact output need?

Re: sorting data in a straight chart

0li5a3a — Tue, 16 May 2017 13:18:24 GMT

your scenario is fine but my data is wrong

Re: sorting data in a straight chart

sanjay006 — Tue, 16 May 2017 16:56:14 GMT

My scenario was not working ?