topic Re: Qikview Expression - Bar Chart in QlikView

Qikview Expression - Bar Chart

rxp03570 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Trying to create a bar chart which should show entire data for dimension [Month Year] if there is no selection for [Month Year] and selected fields with user input.

Can anyone suggest a if case which can be done.

Thanks, Rahul.

Re: Qikview Expression - Bar Chart

Digvijay_Singh — Wed, 28 Mar 2018 17:55:04 GMT

Can you elaborate on selected fields with user input? Can you share actual dimensions, measure expression, sample data, expected output? you will get faster responses over here.

Re: Qikview Expression - Bar Chart

rxp03570 — Wed, 28 Mar 2018 18:00:30 GMT

Trying to display [Month Year] with Sum(Sales) in a bar chart, if the user selects any [Month Year] it should just display those selection for [Month Year] if not it should should all the available data set for the [Month Year]

Does this explain?

Re: Qikview Expression - Bar Chart

rxp03570 — Wed, 28 Mar 2018 18:01:44 GMT

Something like

if(GetSelectedCount([Month Year])=0,{1<[Month Year]>},[Month Year]).

Please excuse my set analysis, trying to learn 🙂

Re: Qikview Expression - Bar Chart

MK_QSL — Wed, 28 Mar 2018 18:05:47 GMT

If you simply use

Month Year as dimension

SUM(Sales) as an expression..

This should work..