Hello guys.

I am new at qlikview .

I have data from 2021 & still going on.

I want to create a button that it will take data from the current month of the current year.

Any suggestion?

thank you for your time.

hi,

i can see a number of posts showing how to lock a visulsaition using {1} .

however im having trouble getting this to work on my formula:

='$(vMaxID) / $(vTotal)'

is it possible to lock the above formula so selections dont impact my vMaxID value?

thanks 

Hello!

I have the following graph, and you can see the gray on top of each year. I want to get rid of that. The grey orders are as '-' classify. I tried using the following but it did not work out : If(Order Type <> '-', sum(amount))

I know I can deselect the option " Include Null Values", but if I do that, the rest of my dashboard will not make sense. 

What can I do? Can I solve this with an if function?

The pic is attached

Hi please help me to solve the below issue attached excel

how to select the period from the list box is there any expression, and how to find the previous year from the current selection year, to find the difference between two quaters

HI,

 I am reading many data's from Servicenow Through API. but is there any option to write in Service now from QLIK.

basically, I have a table in qliksense. App will run for every 15 days. table is for comparing 2 different datasets. if value is not matching, table will show mismatch and server details

If I have mismatch in table, it has to trigger SERVICENOW and create Incident to Respective teams. Is there any way to achieve this?

I have a generic table with below fields
ID,
TYPE1,
TYPE2,
TYPE3,
TYPE4,
"COUNT"

What will be the best way to put this table in data model where the number of records expected is 9999999

1)Use a generic Load and store all tables created as individual QVD files with a for loop and map it to the actual fact table with ApplyMap. 
Since each TYPE has 2 to 8 distinct values, the number of QVDS could be too many

DATA:
Generic
LOAD
ID,
TYPE1 & '_' & TYPE2 & '_' & TYPE3 & '_' & TYPE4,
"COUNT"
resident GENRICTABLE ;


2) Use if condition for each fields and have association to the other fact table. Number of If condition could be too many.

DATA:
LOAD
ID,TYPE1,
TYPE2,
TYPE3,
TYPE4,
if (match(TYPE1,'J'),if (match(TYPE2,'P'),if (match(TYPE3,'D'),if (match(TYPE4,'C'),COUNT)))) as JPDC,
.
.
.
if (match(TYPE1,'K'),if (match(TYPE2,'P'),if (match(TYPE3,'D'),if (match(TYPE4,'C'),COUNT)))) as KPDC,
resident GENRICTABLE ;

3) Write multiple left joins to actual fact table

Left join(FACT)
Load ID,
COUNT as JPDC from GENRICTABLE where TYPE1='J'
and TYPE2='P' and TYPE3='D' and TYPE4='C';
.
.
.
Left join(FACT)
Load ID,
COUNT as JPDC from GENRICTABLE where TYPE1='K'
and TYPE2='P' and TYPE3='D' and TYPE4='C';

I understand that there are lot of factors like data density for each types ,my final data requirement etc. to be considered. It will be helpful if any one could provide a direction in which I will have to do the thinking.

@sunny_talwar Can you please provide your thoughts