Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Classic Search
Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
- Qlik Community
- :
- All Forums
- :
- Search
Search
Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
111,920 results
Sorted by:
2011-06-10
12:36 PM
Is there an easy way to exclude values from an expression that don't appear in all returned values of the dimension. ie i would like to be able to only return Like for Like values. eg I want to b...
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (7)
-
...asier solution like: Sum( {$<SiteName = { "=(count( DISTINCT Year(FootballDate) )=4)" }>} [I...
-
Hi Lawrence, The easiest way is to have 2 fields - one for AND and one for OR. You can then c...
-
Hi Stephen, Thanks for this and you blog posting, that commuicated my problem it more clarity t...
-
...ant. Perhaps you could post an example QVW showing what you are looking for? I am guessing t...
-
...ales, having data for 2010 and 2011. The Like for Like KPI for a shop should compare only the m...
-
...ooking to have a flag or button where I can switch from all results to just like for like results. i...
-
Hello Angelos, I like your approach it is extremely interesting. Do you have any example for...
2009-05-05
02:47 PM
Hello, how do I make a "like for like" KPI in QlikView? regards Bastian
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (9)
-
...sing-flags-to-avoid-if-formulas.aspx One approach would be to set a "sameStore" flag to 0 or 1 (0-n...
-
Hi Bastian, Did you ever come up with a work able solution for 'Like for Like' reporting. ie e...
-
...ou could also do the same for month. I used standard week conventions so I could compare the Monday o...
-
Hallo John, the period could be a day, a week or a month wich is compared to the last year. Is it...
-
...e with a join. Something like this, perhaps: [MyTable]: LOAD store ,date ,turnover FROM d...
-
Hello, I like the idea of flags. My Like for Like definition says that the store must have t...
-
You could also do it directly in the expression. Something like this: if(sum({<Year={"<$(=m...
-
Hello Oleg, we compare retail stores from the current year with the last year. And the "like for like...
-
what do you mean by "like for like" ? Please explain ... Oleg
2013-05-30
07:54 AM
Good morning, I need your help in a calculation. So, I need to show brands that have continuous sales in past year (if doesn't exists any period bigger than 5 days without sales) This can be...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2014-01-31
04:46 AM
is there a like function in qlikview? I have a column called "bonus_description" and it has both letters and numbers in it, for example "new member 100% bonus" what I want is to replace all "new m...
- Tags:
- new_to_qlikview
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (5)
-
...umbers besides the percent like "20130630 50% bonus" and "44% 23.03" how do I remove 20130630 w...
-
Hi Abbasi, You can use Keepchar() function. Use like this in your script Keepchar('b...
-
Keep char works in this way: keepchar ( 'a1b2c3','123' ) returns '123' This is not "like...
-
to answer your question. You can use LIKE in Qlikview However, the above will not g...
-
try this Zainab
2013-07-15
11:29 AM
Dear QlikView fanatics, I have a quistion about indirect set analyses: I think it should be possible to do the folowing: Sum Turnover(#Netvalue_EUR) of this year where store is open(store...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2016-03-03
01:49 PM
Hi I'm trying to map a field "seller risk" to a "Highest risk" field. The seller risk's value has multiple seller and their risk, for example "Apple - Low; Microsoft - Medium; Nokia - High" T...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2012-05-02
06:28 AM
1 Like
hi.. what is the equivalent of "not like" in the qv script?
- Tags:
- new_to_qlikview
Labels
- Subscribe by Topic:
-
QlikView App Dev
2017-08-07
04:06 PM
Hi, I have a field with emails, the idea is to have the sum of views that the users are making to some documents. But I will like to exclude the emails that are like '@gmail.com' for example....
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (4)
-
Hi Roberto, Maybe something like: Count({$<email -={'*gmail.com'}>}ViewID) You will n...
-
May be like this =if(SubStringCount(Email,'gmail')=1,0,Count(ID))
-
May be like Not WildMatch() function. Can you explain a little more if below is not what you are e...
-
...xpression in chart like below =count({<EmailFlag={0}>} ID)
2011-04-01
06:02 AM
Hi I'm looking for a function: my data is in this format: 32-GH-47 and i would like to quit the '-' caracter. As well, how do i quit the space in a middle of '26 AK 25' ? Thanks
Labels
- Subscribe by Topic:
-
QlikView App Dev
2012-07-04
09:58 AM
1 Like
It's possible to use like function in Set Expression? What's the exact sintax for this? Thanks a lot. Nutis
Labels
- Subscribe by Topic:
-
QlikView App Dev