Default selection of dimensions

[qlikviewwizard]

Hi All,

I want to show dimension columns dynamically by selecting values.

Used the below formula:

=SubStringCount(Concat(Lable, '|'), 'Job')

Requirement is I want show always 3 columns (EmpNo,Name,Sal) without selecting any value from the list box.

These are the values from the list box:

EmpNo

Name

Department

Job

ID

HireDate

Please help me in how to achieve this.

[kaushiknsolanki]

Hi,

Here is the solution.

[qlikviewwizard]

Hi All,

If I want to show EmpNo,Name,Sal, these can be selected in Led Check box. But default it should be selected EmpNo,Name,Sal.

How can I achieve this?

Please help.

[jagan · Accepted solution]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[jagan]

FYI, i have used below condition

For default columns OR GetSelectedCount(Lable) = 0

For non default columns AND GetSelectedCount(Lable) <> 0

By default it will show the default columns even if not selected in the listbox, if selected then it will show the selected values in the chart.

Hope this helps you.

Regards,

Jagan.

[qlikviewwizard]

Dear Jagan,

Many Thanks for your help.