Qikview Expression - Bar Chart

[rxp03570]

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.

[Digvijay_Singh]

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.

[rxp03570]

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?

[rxp03570]

Something like

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

Please excuse my set analysis, trying to learn 🙂

[MK_QSL · Accepted solution]

If you simply use

Month Year as dimension

SUM(Sales) as an expression..

This should work..