Hi Folks,

Could some one help me on this following requirement.  

How to sort bars by measures level in Bar chart. I am having a bar chart in the following 

In the above chart if we look at dimensions Hard disk.  Lower value is 4  and Actual is 0. So  1st bar should be Actual & 2nd bar should be Lower Value.

If we look at dimension USB Lower value is 20 & Actual is 17. So 1st bar should be Actual & 2nd Bar should be Lower Value.

There is one more Dimension  Mouse. In this case 1st bar is Lower , 2nd bar is actual & 3rd bar is Upper. So these bar should be in ascending order. 1st bar should be Lower and 2nd bar should be Upper and 3rd should be Actual.  

Could some one can please help me  to resolve this Issue. Is this possible in Qliksense? Please let me know and you can find the data and sample qvf files in attachments

Thanks and Regards,

Satya

Trying to set up a mashup with two apps and shared filters.  There is a listener on the selectionState of the first app like this:

which sets the field selectValues of the second app.  This works for some fields but not all.  I looked at one of the problem fields using

app.field('METRIC DATE.YEAR').getData();

compared to:

app1.field('METRIC DATE.YEAR').getData();

and it is identical in both apps.  I also tried setting it directly as numeric and text:

app1.field('METRIC DATE.YEAR').selectValues([2016], true, true);

app1.field('METRIC DATE.YEAR').selectValues(['2016'], true, true);

but no luck.

Any ideas on what to try next?

Hi,

I am facing the below issue for Pie chart.

I have 5 columns with Data ex: A1,A2,A3,A4,A5. Now need to build pie chart. Here is the data for these columns.

Pie chart should have count of all A's(5 Columns),B's,C's,D's,E's.

A - 4

B - 4

C - 4

D - 2

E - 3

Can any one help me how to do that.

Appreciate for quick help.

Hello All,

I need to hide a tab in the qlikview dashboard for Users whose Access is not Admin.

I tried to use the column Access in the section file . 

Created one table with the column Access called USer_Access so that it joins with the Access column in the security table .

 I added a condition in the sheet properties to show for Access='ADMIN'. 

When I refresh the file , it opens in Qlikview Desktop but doesnt oopn in Access Point.

Please advise

Thanks 

Kusha 

I am trying to highlight one bar in a stacked bar chart.  In a simple bar chart, I can color by expression so whatever I have selected will be a single color and all other data will be a different color.  But in a stacked bar, I need to leave the color alone so each piece in my stack has its own color.  I would like my selected bar to be bold.  I have attached two pictures - "Graph" is of the stacked bar graph and "Selected" shows what I would like it to look like when a bar is selected (I selected bar 31 for the example).  I tried searching for this but didn't have any luck.  And suggestions would be great.  Thank you!

GRAPH:GRAPH

SELECTED:

SELECTED

Hi,

I've trying to do this in the script, managed to do it with an expression.

I want to find the lowest priced product per SubId and apply a discount (in this case 50%) and then sum the Totals.

FirstsortedValue should work i guess but I'm doing something wrong 🙂

This is the expression:

(Sum(FullPrice)
-
(Min({<flgNewOrder = {'1'}>} Aggr(FullPrice, [Product ID]))
*0.5))

I am developing in Qlik Sense Business, and constantly get either one of the below messages. When I say constantly, I mean about every 5 minutes. Every time you need to do a refresh or close, your last changes are gone. The machine is not left idle, I am working on a new App. 

I have a fibre line with 20g upload and down load. I also have a 4G standby router. The issue is the same no matter which service I use. I have done the rebooting of the router thing!

Has any experienced the issue and found a solution? If so, please can you share your solution. Thank you.

Hello,

I am trying to find an error in some script that was developed for us by a third party. We have a report that has stopped working due to the knock on effect of our date calendar now projecting to 2020. I can see in the variables that a variable called varMaxDate is calculating a value 43887 (in Excel this is showing me it is 26/02/2020 which is the date in Qlik too).

I have used the find function to look through all of the sections within the script and the only mention of the variable varMaxDate is in the below script. 

//CalDate field exists elsewhere in script and is the link. Example: date(InvoiceDate, 'DD/MM/YYYY') as [CalDate],

QuartersMap:
MAPPING LOAD
rowno() as Month,
'Q' & Ceil (rowno()/3) as Quarter
AUTOGENERATE (12);

Temp:
Load
min(CalDate) as minDate,
max(CalDate) as maxDate
Resident Fact;

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
DROP Table Temp;

TempCalendar:
LOAD
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

MasterCalendar:
Load
MonthStart(date([TempDate],'YYYYMM')) as Period1,

Date(monthstart(TempDate), 'YYYYMM') as CalYearMonth,

12*(Year(Today())-Year(TempDate)) + Month(Today()) - Month(TempDate) as MonthsAgo,

// MonthStart(date([TempDate],'YYYYMM')) as Period1,
TempDate AS CalDate,
Date(monthstart(TempDate), 'MMM-YY') as CalMonthYear,
week(TempDate) As CalWeek,
Year(TempDate) As CalYear,
Month(TempDate) As CalMonth,
Day(TempDate) As CalDay,
ApplyMap('QuartersMap', month(TempDate), Null()) as CalQuarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as CalWeekYear,
weekstart(date(TempDate, 'DD/MM/YYYY')) as [CalWeekCommencing],
WeekDay(TempDate) as CalWeekDay
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;

As I'm still new to Qlik I cannot figure out why this script is generating 26/02/2020 for the calendar. Any help would be great!