topic Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense in App Development

How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Wed, 13 Dec 2017 12:30:00 GMT

How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense.

Like select month then I want to see data for selected months in the pivot table and do not want to see data for other months and no need to use scroll bar if I use random month data in the table...

Somebody help for this query

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

kuczynska — Wed, 13 Dec 2017 13:35:35 GMT

Hi,

did you try adding calculation condition to your chart with GetSelectedCount(fieldname) >= 1 ?

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Wed, 13 Dec 2017 13:50:43 GMT

Shall I use in Measure means Calculation condition?

In the calculation condition..I am using If condition for calculation

I will try and let you know..Thanks for reply.

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

kuczynska — Wed, 13 Dec 2017 13:57:48 GMT

It's Calculation condition window in Add-ons > Data Handling panel - something like this:

with your expression like:

f(GetSelectedCount(FieldName) >=1, 1,0)

You can also change the displayed message to something else.

Good luck!

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Wed, 13 Dec 2017 14:05:23 GMT

I am working at client location..

I will check and let you know..May be It will work

Thanks and appreciate your quick responses..

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Thu, 14 Dec 2017 08:50:10 GMT

Hi Mic,

I tried below syntax for selecting current data view but it's not working, I am getting error as it's showing error in message

If(GetSelectedCoun t(

if([Client Type] ='Individual' or COUNTRY = ' SGH', (sum(Values) - (Value))/(sum({1}Values)),

if([Client Type] ='Individual' or COUNTRY = ' SGHJ',(sum(SGHJValues) - (Value))/(sum({1}SGHJValues)),

if([Client Type] ='Individual' or COUNTRY = 'ARG',(sum(ARGValues) - (Value))/(sum({1}ARGValues)),

Null()))))>=1,1,0)

Can you please suggest other option..I have tried GetCurrentSelections but it is also not working

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

kuczynska — Thu, 14 Dec 2017 09:07:11 GMT

Hi,

I think you are trying to put both calculation condition and measure itself into the calculation condition box, which doesn't seem correct. In Calculation condition box you should only put your statement - something like:

if(GetSelectedCount(Month) >=1, 1,0)

to initiate the calculation of your chart.

In your measure box you should still put your sum(Values) expressions, just like you did before you set your calculation condition (so there are no changes required to your measure at this stage).

As per QSense Help guide - maybe ready some more about how they can be used in your app.

GetSelectedCount() finds the number of selected (green) values in a field.

GetFieldSelections() returns a string with the current selections in a field.

Good luck,

Micha

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Thu, 14 Dec 2017 09:31:48 GMT

I am waiting reply on my request. Appreciate for quick response..Thanks in advance

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Thu, 14 Dec 2017 09:35:56 GMT

I used below condition before replied but it was not working..Showing error as calculation condition not fulfilled

If(GetSelectedCount(Month) >=1, 1,0)

GetFieldSelections() is also not working

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

kuczynska — Thu, 14 Dec 2017 09:54:07 GMT

Now you have to select something on your filter Month, as per below:

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Fri, 15 Dec 2017 09:13:06 GMT

Facing issue while using condition as If(GetSelectedCount(Month) >=1, 1,0) PFA screen shoe

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Fri, 15 Dec 2017 09:13:58 GMT

Can you please suggest something which will helpful to view selected month data

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

kuczynska — Fri, 15 Dec 2017 09:15:51 GMT

did you try selecting any of the months from your filter pane?

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Fri, 15 Dec 2017 09:28:57 GMT

Yes..But not able to view data

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Fri, 15 Dec 2017 11:58:30 GMT

Pivot table containing 2 Years data and while selecting random month, we have to scroll the bar while view the data.

Can you please help me to fix this issue. I want to view selected month data and not able to see unselected data..

Interested in current selection data on basis of Month.

Appreciate for your quick response..

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Sat, 16 Dec 2017 11:56:19 GMT

Hi,

I am loading this data table and created dashboard. all months data are reflecting in the pivot table.

When I select month then I want to see only selected month data and other month data column should no display but when I selected random month , scrolling the scroll bar of the table to view the data.

Client want to see only current selection data on the basis of year and month.

I have used below condition in the measure to calculate % (Percentage) .

if([Client Type] ='Individual' , (sum(Values) - (Value))/(sum({1}Values)),Null())

somebody help to fix that issue. Tuesday. I will give presentation to client and before that I want to fix that issue.

Appreciate for quick responses.

Michalina Kuczynska had helped me with some solution and logic condition but it's not work. Thanks Mic for your efforts/

Still finding solution....................

Tables:

Database_SGH:
CrossTable (Month, Value, 7)

LOAD
    "Data Elements",
    "FCC Top 20",
    "Client Type",
    "DQ Dimension",
    COUNTRY,
    CLIENT_ROLE,
    DE_KEY,
    "12/31/2016",
    "1/31/2017",
    "2/28/2017",
    "3/31/2017",
    "4/30/2017",
    "5/31/2017",
    "6/30/2017",
    "7/31/2017",
    "8/31/2017",
    "9/30/2017",
    "10/31/2017",
    "11/30/2017",
    "12/31/2017"

FROM [lib://AttachedFiles/Data Profiling Template.xlsx]
(ooxml, embedded labels, table is Database_SGH);

Total_SGH:
CrossTable (Month, Values, 1)

LOAD
    "Client Type" as SGH_Client_Type ,
    "12/31/2016",
    "1/31/2017",
    "2/28/2017",
    "3/31/2017",
    "4/30/2017",
    "5/31/2017",
    "6/30/2017",
    "7/31/2017",
    "8/31/2017",
    "9/30/2017",
    "10/31/2017",
    "11/30/2017",
   "12/31/2017"

FROM [lib://AttachedFiles/Data Profiling Template.xlsx]
(ooxml, embedded labels, table is Total_SGH);

Re: How can remove scroll bar in qliksense and able to view selected data instead of scroll the table in qliksense

vlakeshr — Mon, 18 Dec 2017 12:21:05 GMT

Any suggestion or helpful guidance which can use and check it...