Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to multiply the value 300,000 in column 2 * the Rank(Relative). But I can't get the correct value.
What would the set analysis look like between column 2 * column 3?
Cod | Descrição do Produto | =300000.00 | Rank | Column(2) * Column(3) |
Curret |
10757 | Papel Hig Rolao 8x300 Lirios Branco | 300000 | 7,27% | 15025827000,00 | 9020,773 |
12305 | Fita Ades. Plast. 48x50 Ref.300 TRA Transp. | 300000 | 4,10% | 8461812000,00 | 63619,31 |
13248 | Arquivo Morto Pap. Ond. Compacto Ref.1170 Marrom | 300000 | 3,01% | 6213060000,00 | 12285,75 |
13697 | Papel Hig Rolao 8x300 Lirios 100%Cel | 300000 | 11,97% | 24739770000,00 | 14068,45 |
16923 | Seven Denso Desengraxante Plus 1:100 5Lt Ref.5260 | 300000 | 6,23% | 12882420000,00 | 4802,176 |
17459 | Papel Sulf. A4 75g/m² 500Fls Branco Chamex | 300000 | 24,93% | 51509256000,00 | 35919,8 |
19201 | Papel Toalha Bob 8x100m Bromelia 100%Cel | 300000 | 5,18% | 10710954000,00 | 21816,07 |
19303 | Papel Hig Rolao 8x500 Lirios 100%Cel | 300000 | 6,45% | 13334085000,00 | 19359,82 |
2061 | Lápis Dermatográfico Ref.7600 Branco Mitsubishi | 300000 | 4,69% | 9689652000,00 | 74786,54 |
29976 | Luva Nitríl. s/Pó c/100Un PQ Talge Ref.7240 Azul | 300000 | 1,60% | 3307500000,00 | 15551,29 |
5277 | Copo Desc. 180ml c/100Un Branco Copobras | 300000 | 21,21% | 43817820000,00 | 10065,97 |
5543 | Pincel Marc. p/Retrop. 2.0 Azul Pilot | 300000 | 3,36% | 6932937000,00 | 18704,05 |
Good day
Live story slides are really useless to us without being able to filter on the underlying sheets.
Qlik seems to ignores the current selections made in the dashboard.
Is there a way to export the data to PDF/PPT per current selections? (embedding a live sheet in the story and capture the latest filters).
Please help. The entire project is hinged on this!
Hi All,
A customer is considering moving from on-premise to Cloud and as part of the due diligence, we are exploring compatibility with the services we want to transfer.
They recently signed a license for Qlik Analytics Platform to primarily embed analytics in external sites for anonymous visitors. A requirement for QAP is that there needs to be an enterprise server up and running.
With Qlik Cloud, is there an equivalent product that does the same thing as QAP with being able to deliver custom analytic solutions using backend/frontend APIs that target unlimited anonymous users?
Hi everyone,
we are facing issue with custom filter (inline load filter) , selections are are not working with respect to that selection- how that filter will work
we have multiple filters but 3 are important year and month and filter
1)user will select year and month and Filter(Custom Field) then chart respond based on selection only and legends as well
2)user will select multiple year and multiple months and multiple filter fields based on that selections
data has to show selected one only- Legends as well
3) user will select only filter then selected data has to respond - Legends as well
need your help on this issue.
Hi, Below is the master calander we are using and the fiscal start month is = 7.
Here I want o calculate the daynumber starting month July every year.
Datefield:
LOAD date($(varMinDate)+IterNo()-1) AS DateNum_Fisacal
AUTOGENERATE (1)
WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);
Set vFM = 7 ; // First month of fiscal year
Calendar:
Load * ,Dual(fYear-1 &'/'& fYear, fYear) as FYear, // Dual fiscal year
Dual(Month_F2, fMonth) as FMonth; // Dual fiscal month
Load *,Year_F2 + If(Month_F2>=$(vFM), 1, 0) as fYear, // Numeric fiscal year
Mod(Month_F2-$(vFM), 12)+1 as fMonth; // Numeric fiscal month
Load Year(DateNum_Fisacal) as Year_F2, // Your standard master calendar
Month(DateNum_Fisacal) as Month_F2,
DateNum_Fisacal
Resident Datefield;
I have an Application, In that a button is given to reload the data from the Sheet. Is there any possibility that the reload can be the done from the user end after publishing and giving access to the users to that dashboard.
Thanks in Advance.
Hello everyone,
With the new release:
- A user with analyzer entitlement and has restricted view role in a managed space can export data
- A A user with analyzer entitlement and can view role in a managed space can export data and ... ??
Could you help me with the second statement ?
Thank you
Hi,
According this Backup guide
I should select the option "Personal information exchange" but I can't select it.
Is it necessary to use this option if I want use Qlik sense to be activated on another server (same version) ?
If I choose first option for example (.CER), will it change anything?
* Qlik sense version - May21
Thanks.
I have not found specific information about this elsewhere
Hello,
I need some help scheduling a task to start running :
- on the last day of the month
- and run every 5minutes
The app take about 1 minutes to run but is setup to pick different load each time until all the last load
Thank you
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!