Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to include a test in a set analysis. The expression that is not in bold works fine. I just need to include a condition now, i.e I need to sum the sales when weeks_left_to_event was a smaller number than current_weeks_left_to_event
=Rangesum(Above(Sum({<year_event=, weeks_left_to_event<={"current_weeks_left_to_event"} ,month_event=, event_code=p(previous_event_code), event_to_compare=, event_name= >} quantity), 0, RowNo()))
Any help much appreciated!!
Hi,
I am creating a pivot table where I have a measure which gives a count of ID. I need to to make it a dimension and collapse it so that it shows the count and upon clicking the expand option, I have to see new set of dimensions which will give the data for the count.
Something like this
Dim1 | count | |||
ABC | 200 | ID | Name | Country |
1 | aa | A | ||
2 | ab | B | ||
3 | bc | N |
Hi There,
I have the following SQL query, which retrieves data for the last 5 years based on the snapshot taken at the start of the financial year. I would like to make it dynamic so that I don't have to modify the code next year.
I would greatly appreciate your guidance on how to achieve this.
I'm trying to combine 2 different qvd's into one table. Here is what I have.
INVOICE:
LOAD
hdr_key,
entity as [entity code],
[cash discount amt] as [amount],
[cash discount gl account] as [gl account]
FROM $(vPathNameLayer1)inc-hdr-all.qvd(qvd);
JOIN
LOAD
hdr_key,
line_key,
[line gpsa] as [amount],
[line item gl account] as [gl account]
FROM $(vPathNameLayer1)inc-line-all.qvd(qvd);
When I do this then entity code is not showing up for anything from the second join. How do I accomplish this? Here is what I would do in SQL but it doesn't like the syntax.
JOIN
LOAD
hdr_key,
entity as [entity code],
line_key,
[line gpsa] as [amount],
[line item gl account] as [gl account]
FROM $(vPathNameLayer1)inc-line-all.qvd(qvd) as a,
$(vPathNameLayer1)inc-hdr-all.qvd(qvd) as b
WHERE a.hdr_key = b.hdr_key;
Greetings.
Is it possible to split data on the load coming in from excel in a single column (InputField) into multiple columns using the blank rows between questions as a delimiter?
Current...
InputField | |
____ Yes, we use this practice today |
|
____ No, we have a different practice in place | |
2. Question2? | |
____ Yes, they can do this independently in all scenarios | |
____ Yes, they can do this independently in some scenarios | |
3. xxxxxx |
Desired...
newcolumn1 | newcolumn2 |
Question1 ____ Yes, we use this practice today ____ No, we have a different practice in place |
Question2 ____ Yes, they can do this independently in all scenarios ____ Yes, they can do this independently in some scenarios |
|
Hello Experts,
I have data since 2021 in my model.
I have to create Line Chart by MOnth/Year, the expression of Chart is as based on Running sum of last 12 months as per below.
((sum({<DESCRIPTION=,PARTNO=>} [FA_QTY_FUNC] * [AVERAGE_PRICE])
/
Rangesum(Above( Sum({<DESCRIPTION=,PARTNO=>}CONSUME_AVG_PRICE_FUNC),0,12)))
)*365
now as we have data from 2021 for whole 2021 our expression will not calculate correct running sum of last 12 months. so we want our graph shows only month onwards Jan-2022.
As soon as i am trying to do so my RangeSum() is considering Jan2022 as First month starts summing value from Jan2022 only. and my calculation starts showing wrong data as per functional requirement.
Can we have some expression which will give us last 12 month SUM even if we are showing it in Dimension.
Thanks in advance.
Hola,
Ens trobem que durant 2 dies de feina, el 3r dia no queda constancia de res.
En cap moment s'ha fet una recuperació de bbdd ni hi ha errors a la màquina.
Algú ha tingut aquest error?
Per altra banda, alguna guia per fer les copies de seguretat del qvd (bbdd postgrsql) i les Apps?
VERSIÓ: Qlik Sense Febrary 2021 Pach 6, qliksenseserver:14.5.18
Gràcies.
Hi,
I have a workflow, where I need to reload massive csvs into some BI tool. Of course, it is much easier to do, if data is compressed into some format or written as RAM dump.
1st approach (compressed) is used in Qlik and Tableau, qvd and tde respectively.
2nd approach (RAM dump) is used in Parquet/Arrow (I use it thru Python/Pandas).
Question - Is there _any_ compressed or RAM optimized format, supported by Power BI?
I mean, free easymorph can read qvd and tde (Tableau), but Power BI can't?
Free python/pandas can read/write RAM optimized files, but Power BI can't?
xlsb (binary Excel) is great, but Power BI is extremely slow with it, even it is the MSFT technology.
Also, Power Bi desktop can't read another pbix (at least I don't know how to do this).
Any suggestions? Thanks!
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!